Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “explicitnesses” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
explicitnesses256131(None) 
explicitness2351662explicitne_s_s
implicitnesses2061812implicitnesses
licitnesses1346413___licitnesses
exactnesses2044344ex__ac_tnesses
exoticnesses2142684exotic__nesses
expertnesses2144844exp__ertnesses
explosivenesses2793924explosivenesses
exquisitenesses3162794exquisitenesses
implicitness1851904implicitne_s_s
placidnesses1743954__placidnesses
pliantnesses1444454__pliantnesses
spicinesses1547104_sp_ici_nesses
earlinesses11311045earl__i_nesses
earwitnesses1543785e__arwitnesses
electresses1345975e__lec_tresses
emptinesses1545995emp__ti_nesses
erectnesses1347475e__rec_tnesses
ethicalnesses1853205e_thicalnesses
exclusivenesses2764665exclusivenesses
exemplarinesses2661185exemplari_nesses
expansivenesses2794525expansivenesses
expectednesses2662955expectednesses
expensivenesses27105495expensivenesses
explicates2196665explicat____es
explicits2044935explicit_____s
eyewitnesses1852115e__yewitnesses
flintinesses1546325__flintinesses
icinesses11310075____ici_nesses
juicinesses2035895__juici_nesses
lacinesses12312125___laci_nesses
licitness1145375___licitne_s_s
lightnesses1546145___lightnesses
liminesses121310855___limi_nesses
lividnesses1545025___lividnesses
lucidnesses1445245___lucidnesses
pickinesses1996835__p_ickinesses
pipinesses1448605__p_ipi_nesses
pixinesses1937375__p_ixi_nesses
plainnesses1356205__pl_ainnesses
pluckinesses2043995__pluckinesses
prolificnesses2151165prolificnesses
publicnesses1842665public__nesses
selectnesses1446115_selec_tnesses
slicknesses1745195__slic_knesses
slightnesses1654625__slightnesses
sliminesses1338095__slimi_nesses
spacinesses1538105_sp_aci_nesses
spikinesses1746525_sp_iki_nesses
spininesses1358455_sp_ini_nesses
strictnesses1445415_stric_tnesses
tacitnesses1336325___tacitnesses
toploftinesses1951275toploftinesses
typicalnesses2062545typ_icalnesses
uppitinesses16103705_uppiti_nesses
uprightnesses19122785_uprightnesses
uptightnesses1982225_uptightnesses
valiantnesses1652725_valiantnesses

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691950240.343520965.0
2DLD Change Limit95024585.97015916.9
3Display Results58580.0461260.9
 (SQL Overall)178691586.35928100.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.