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

108 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
emplaced153605(None) 
emplace1338261emplace_
emplaces1438411emplaces
emplaned1337161emplaned
emblazed2244742emblazed
embraced15106672embraced
empaled12288952emp_aled
emplane11410012emplane_
emplanes1239502emplanes
employed1654952employed
emulated11310792emulated
enlaced102410522e_nlaced
enplaned1137482enplaned
placed114318002__placed
replaced133211402replaced
unplaced1338612unplaced
belaced124112153_belaced
deplaned1238663deplaned
displaced1546793displaced
effaced16225573e_ffaced
elated74725823e__lated
emanated1139163emanated
embalmed1544263embalmed
embayed1535443em_bayed
emblaze2045773emblaze_
emblazer2144563emblazer
emblazes2135673emblazes
emblemed1544273emblemed
embrace1388893embrace_
embracer1496463embracer
embraces14128873embraces
empale102611263emp_ale_
empaler11288353emp_aler
empales112411433emp_ales
empanel1145963emp_anel
emphases1568353emphases
emplacing1645483emplacing
employe1476363employe_
employee1555203employee
employer1564713employer
employes1555943employes
emptied1297393emp_tied
emulate9314123emulate_
emulates10312573emulates
enclaved1456343enclaved
endplayed1642783endplayed
enfaced13218913e_nfaced
enflamed1455723enflamed
enlace82213233e_nlace_
enlaces92313393e_nlaces
enplane939723enplane_
enplanes1039483enplanes
enslaved1245063enslaved
epilated11310753epilated
expiated18168523expiated
explained1944543explained
explanted1944973explanted
exploded1944753exploded
explored1845083explored
imblazed2243763imblazed
impacted15286353imp_acted
impaled12288513imp_aled
impeached1942983impeached
implanted1475493implanted
impleaded1543933impleaded
impled113812513impl__ed
implied1238623impl_ied
imploded14145073imploded
implored13135373implored
inlaced10239873_inlaced
laced87132643___laced
maced108528693_m__aced
melamed1249633_melamed
menaced122710093_menaced
misplaced1646253misplaced
necklaced1842593necklaced
noplace1137393noplace_
outplaced1446353outplaced
paced106931683__p_aced
palaced124110773_palaced
peaced115818913__peaced
place94824613__place_
placer105117743__placer
places104323703__places
placet103923673__placet
placid114012543__placid
planed94420913__planed
plated95225773__plated
played124815033__played
preplaced1676483preplaced
relaced103517213_relaced
replace113214283replace_
replacer12279743replacer
replaces123114123replaces
replated112817523replated
replayed14248633replayed
respaced1338503resp_aced
respliced1445543respliced
semplice1447013semplice_
solaced102911063_solaced
spaced114517253_sp_aced
splayed13357813_splayed
spliced124310593_spliced
template1238433template_
templates1348273templates
templed12278563templ__ed
unlaced102913733_unlaced
unplayed1437263unplayed

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621087.25020160.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.71923149.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.