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 “desalinators” with Change Limit: [1] [2] [3] [4] [5]

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

81 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
desalinators135360(None) 
desalinator1254351desalinator_
desalinates1246212desalinat_es
desalinations14410182desalinations
decapitators1753263decapitators
defalcators1742863defal_cators
defoliators1543723defoli_ators
delineators1253963de__lineators
denominators1574093denominators
desalinate1146673desalinat__e
desalinated1345773desalinat_ed
desalinating1476313desalinating
desalination13411133desalination
designators1344303des_ignators
desolators1146283desol__ators
salivators13135753__salivators
alienators1045784___alienators
assassinators1261294assassinators
deactivators1852574deactivators
deaerators11107714de_a_erators
deaminates1349384de_aminat_es
deaminations151010134de_aminations
decaliters1345214decali__ters
decapitator1653804decapitator_
decelerators1553494decelerators
decimators1547504de__cimators
declinations15410224de_clinations
dedicators1447744de__dicators
defalcator1643174defal_cator_
deflators13348154de_fl__ators
defoliator1444184defoli_ator_
dekaliters1543414dekali__ters
delaminates1456904delaminat_es
delaminations1647944delaminations
delators92314834de__l__ators
delegators1245634de__legators
delineator1174174de__lineator_
denominator14104714denominator_
depilators1347334de__pilators
deracinates1445864deracinat_es
deracinations1647834deracinations
desalinizations2555394desalinizations
desalinizes2144144desalin_izes
desalters1037674desal___ters
descriptors1652754descri_ptors
desecrators1445234des_ecrators
desiccators1643804des_iccators
designator1244714des_ignator_
designatory1653384des_ignatory
desolaters1146044desol__aters
desolator1046674desol__ator_
destinations13412664des_tinations
determinators1653894determinators
detonators1145854de__tonators
devastators1552924deva_stators
deviators1358544de__vi_ators
disseminators1653084disseminators
dominators1397484d__ominators
duplicators1644294d_uplicators
eliminators1344814_eliminators
emanators1147034_ema__nators
eradicators1445284_eradicators
escalators1245304_escal__ators
estimators1247024_es_timators
estivators1345924_es_tivators
evaluators1374594_eval_uators
explicators2244714_explicators
fascinators1644704fas_cinators
hesitators1385854hes__itators
inseminators1453764inseminators
invalidators1652864invalidators
laminators1247054__laminators
pollinators1354544_pollinators
resonators1045814res__onators
respirators1375444res_pirators
retaliatory1453324retali_atory
salivator12136114__salivator_
supinators1245644__supinators
terminators1346034te_rminators
totalisators1251894totalisators
totalizators2151794totalizators

Search took 8 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 Filter1786911247900.393454684.5
2DLD Change Limit124790816.57618976.6
3Display Results81810.0461760.9
 (SQL Overall)178691817.01525472.7
 
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.