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 “cremation” 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.

116 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
cremation1351164(None) 
creation102816511cre_ation
cremations14410711cremations
crenation11412921crenation
chelation1439962chelation
creatin93618132cre_ati_n
creations112614542cre_ations
cremating14312192cremating
cremator1269172cremat_or
crenations12511692crenations
predation12313462predation
relation82619772_relation
remotion10410232_remotion
ademption1443493ademption
aeration8319933_aeration
animation11313683animation
arcuation11410583arcuation
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
catenation1249523catenation
cation83925503c___ation
caudation1269993caudation
causation1199523causation
ceratin93020163c_erati_n
cerebration1547923cerebration
cessation1176853cessation
chelations1539073chelations
chrismation1853513chrismation
chromatin16410753chromati_n
ciliation111112493ciliation
citation10314363c_itation
clavation1447003clavation
clematis1248653clemati_s
cognation12310753cognation
collation11313993collation
commotion1576983commotion
conation101420883c_onation
connation11314263connation
coronation12412073coronation
corotation12410973corotation
correlation1358553correlation
craton84517193cr__at_on
creatine103417413cre_atine
creating113921953cre_ating
creatins103617513cre_atins
creative132812803cre_ative
creator93714433cre_at_or
cremains1238693crema_ins
cremate113816183cremat__e
cremated133412963cremat_ed
cremates124216003cremat_es
cremators1369803cremators
crematory1647193crematory
crenelation1346853crenelation
crenulation1347573crenulation
crepitation1548393crepitation
cretin82917913cre__ti_n
crimination1549413crimination
delation92318083_delation
demotion1169073_demotion
elation73620453__elation
elevation1239233elevation
emotion9711303__emotion
enation73419233__enation
erection102115513ere_ction
exemption2064943exemption
fetation11613143_fetation
formation1439423formation
gelation93014433_gelation
gemmation1445963gemmation
gradation11107713gradation
haematin13148893haemati_n
hematin121516023_hemati_n
himation1339753_himation
ideation9310493ide_ation
iteration9515033iteration
lacrimation1546263lacrimation
legation92412933_legation
negation92913023_negation
nervation12610243nervation
operation11314003operation
oration71617713or__ation
palmation13310223palmation
permeation14410563permeation
precaution1447243precaution
predations13812153predations
preemption16105253preemption
prenotion1149173prenotion
preoption1348083preoption
privation14311173privation
probation13412183probation
promotion1359503promotion
pronation11415703pronation
proration11415983proration
ration64226013_r__ation
reaction10612603_reaction
recaution1148093_recaution
recreation12413613recre_ation
redaction1259663_redaction
reflation12412333_reflation
relations92418333_relations
remain85919863_rema_i_n
remating112322413_remating
remotions1149703_remotions
restation9316913_restation
rogation91612053_rogation
rotation81615453_rotation
sedation9312453_sedation
seriation9318063seriation
serration9414063serration
summation1347803summation
urination9312173urination
venation11513503_venation
vernation12311083vernation
vexation1838783_vexation

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411167.97018650.1
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.18921820.9
 
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.