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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
cremations1441071(None) 
creations112614541cre_ations
cremation13511641cremation_
crenations12511691crenations
chelations1539072chelations
creatins103617512cre_ati_ns
creation102816512cre_ation_
cremains1238692crema_i_ns
cremating14312202cremati_ng
cremators1369822cremat_ors
crenation11412922crenation_
predations13812152predations
relations92418332_relations
remotions1149702_remotions
ademptions1543383ademptions
aerations9317903_aerations
animations12312193animations
arcuations1249343arcuations
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
catenations1348363catenations
cations94524143c___ations
caudations13108223caudations
causations1268143causations
ceratins102818733c_erati_ns
cerebrations1646963cerebrations
cessations1256473cessations
chelation1439963chelation_
chrismations1953043chrismations
chromatins1749123chromati_ns
ciliations121111003ciliations
citations11312503c_itations
clavations1546183clavations
clematis1248653clemati__s
clematises1445733clematises
cognations1339593cognations
collations12312853collations
commotions1686843commotions
conations111318903c_onations
connations12312943connations
coronations13410703coronations
corotations1349773corotations
correlations1447863correlations
cratons94316033cr__at_ons
creatin93618133cre_ati_n_
creatine103417413cre_ati_ne
creatines112814433cre_atines
creating113921953cre_ati_ng
creationism1576463cre_ationism
creationist1379233cre_ationist
creatives14279693cre_atives
creators102814413cre_at_ors
cremates124216003cremat__es
cremator1269193cremat_o_r
crematory1647213cremat_ory
crenelations1446183crenelations
crenulations1446493crenulations
crepitations1647473crepitations
cretins93216423cre__ti_ns
criminations1648063criminations
delations102616593_delations
demotions1258443_demotions
elations83719123__elations
elevations1338633elevations
emotions10610283__emotions
enations83316903__enations
erections112515213ere_ctions
exemptions2164833exemptions
fetations12511383_fetations
formations1538203formations
gelations102513093_gelations
gemmations1545003gemmations
gradations1286863gradations
haematins14147753haemati_ns
hematins131714683_hemati_ns
himations1438803_himations
ideations1039903ide_ations
iterations10413823iterations
lacrimations1645703lacrimations
legations102711923_legations
negations102811963_negations
nervations1359483nervations
operations12312953operations
orations81515803or__ations
palmations1438733palmations
permeations1549883permeations
precautions1546553precautions
predation12313463predation_
preemptions17134853preemptions
prenotions1248293prenotions
preoptions1447643preoptions
privations15310103privations
probations14311083probations
promotions1448783promotions
pronations12314033pronations
prorations12314463prorations
rations74123433_r__ations
reactions11711713_reactions
recautions1247813_recautions
recreations13412253recre_ations
redactions1359133_redactions
reflations13311233_reflations
relation82619773_relation_
remains94117913_rema_i_ns
remating112322423_remati_ng
remotion10410233_remotion_
restations10315843_restations
rogations101510823_rogations
rotations91613843_rotations
sedations10311253_sedations
seriations10316683seriations
serrations10313103serrations
summations1456783summations
urinations10310693urinations
venations12311723_venations
vernations13310333vernations
vexations1937753_vexations

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 Filter1786911406030.403443402.0
2DLD Change Limit1406031186.01623371.5
3Display Results1181180.0631873.0
 (SQL Overall)1786911186.48227567.3
 
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.