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

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

95 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
recreations1341225(None) 
recreation12413611recreation_
creations112614542__creations
procreations1647272procreations
receptions1449742rec_eptions
recitations13314202recitations
recordations1548642recordations
recreating131214582recreati_ng
recreational1455172recreational
recreationist1555742recreationist
secretions12117842secre_tions
accretions1444923accre_tions
aerations9317903ae_r_ations
brecciations1844283brecciations
creatins103617513__creati_ns
creation102816513__creation_
cremations14410713__cremations
crenations12511693__crenations
deaerations12311673deaerations
deceptions1547863dec_eptions
decimations16410163decimations
decorations14312883decorations
decryptions1943613decryptions
deprecations1748563deprecations
depredations1646733depredations
erections112515213_e_rections
excretions1946623excre_tions
execrations2048923execr_ations
federations1548883federations
generations12311423generations
incretions1248653incre_tions
lacerations1348333lacerations
laureations1145573laureations
macerations1548473macerations
miscreations1647063miscreations
nervations1359483ne_rvations
nucleations1345313nucleations
peculations15310283peculations
perceptions1798193perceptions
permeations1549883permeations
procreation1547953procreation_
recantations1448873recantations
recautions1247813rec_autions
recensions1248483rec_ensions
reception13410323rec_eption_
recessions1248933rec_essions
recitation12315943recitation_
reclamations1645713reclamations
recordation1449263recordation_
recrating121318793recr_ati_ng
recreates11313363recreat__es
recreationists1664373recreationists
recreative1549023recreati_ve
recuperations1746083recuperations
redirections1546173redirections
reelections13167943reelections
refections151811643re_fections
reflations13311233re_flations
reflections16178553reflections
reformations1747603reformations
refractions16127723refractions
refutations1448673refutations
regressions1247103regressions
regulations12310713regulations
reiterations12410873reiterations
rejections191510103re_jections
relations92418333re__lations
relaxations1845643relaxations
relegations1248973relegations
relocations13311143relocations
renovations1448423renovations
reoperations14410063reoperations
reparations13611663reparations
repletions1247473reple_tions
repressions1348963repressions
reprobations1647773reprobations
reputations13410733reputations
resections121513033re_sections
reservations1588583reservations
restations10315843re_stations
retardations1396513retardations
retentions101611113re_tentions
retractions13910353retractions
retreating111414773retreati_ng
retroactions1447073retroactions
revelations14410303revelations
revocations16410313revocations
secretins11108463secre_ti_ns
secretion11118293secre_tion_
segregations1445803segregations
seriations10316683se_riations
serrations10313093se_rrations
ulcerations1346363ulcerations
venerations14411313venerations
vernations13310333ve_rnations

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 Filter1786911216330.1401276364.3
2DLD Change Limit121633958.48314338.4
3Display Results95950.0501900.0
 (SQL Overall)178691958.67320603.1
 
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.