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

123 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
realtering113947(None) 
prealtering1446171prealtering
altering91917112__altering
faltering132211112_faltering
haltering132212002_haltering
paltering122612892_paltering
peltering122011672pe_ltering
reentering1149982reentering
refiltering1544822refiltering
remastering1446842remastering
reuttering1137572reuttering
weltering13219492we_ltering
bantering122414233_bantering
bartering122313643_bartering
battering122715143_battering
beavering1538703bea_vering
betattering1444143betattering
bettering122212753be_ttering
blattering13108713blattering
cantering122417373_cantering
catering112019903_ca_tering
centering122915143ce_ntering
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
clattering13109233clattering
cratering12312653cra_tering
dewatering1545773dewatering
elaterin849903_elaterin_
elaterins9410033_elaterins
entering91920053_e_ntering
feathering17108793feathering
featuring1337323fea_turing
festering132413173fe_stering
fettering132310513fe_ttering
filtering13199723_filtering
flattering1498743flattering
gartering112111573_gartering
gettering112310033ge_ttering
greatening1245443grea_tening
heartening1446733heartening
leaguering1243813leaguering
leathering1488683leathering
leistering1147983leistering
lettering102112073le_ttering
mastering122315303_mastering
mattering122314053_mattering
meandering1446983meandering
metering112915633me__tering
misaltering1445123misaltering
nattering102212213_nattering
neatening1038353nea_tening
neutering1038963ne_utering
pattering122314423_pattering
pestering122315663pe_stering
petering112516813pe__tering
philtering1646253philtering
plastering1339243plastering
quartering2045843quartering
rapturing1245353r_apturing
rattening10288763r_attening
reacceding1644223reacceding
reacting113317893react__ing
realigning1245933realigning
realising10313173real_ising
realizing19313813real_izing
realter73716313realter___
realtered1037893realter_ed
realters83614043realter__s
reannexing1843153reannexing
reappearing1643943reappearing
rearing83128783rea___ring
reasserting1246153reasserting
reassuring1155943reassuring
recapturing1643763recapturing
rechartering1853543rechartering
recovering1647373recovering
refastening1544303refastening
reflexing2035933refl_exing
reflowering1843173reflowering
regathering1645203regathering
registering1346393registering
rehammering1953363rehammering
reinterring1245363reinterring
relabeling1344193relabeling
relating92725443relat__ing
relettering1255513relettering
reletting102713943re_letting
relieving1336693re_lieving
renaturing11176803renaturing
rendering112213183re_ndering
reoffering1744093reoffering
reordering1266213reordering
repapering1547043repapering
repatterning1552173repatterning
replastering1553413replastering
repowering1645273repowering
resilvering1593743resilvering
resoldering1343993resoldering
restoring10314613re_storing
restring91518783re_st_ring
retearing102214253re__tearing
retiring92717413re__tiring
revering122918073re__vering
roistering1148583roistering
roystering1445413roystering
scattering1398013scattering
shattering1498283shattering
sheltering1446493sheltering
skeltering1545003skeltering
smattering1397583smattering
spattering13107793spattering
sweltering1445233sweltering
tattering102212323_tattering
teetering10239893te_etering
telfering1336253te_lfering
tentering102313203te_ntering
unfaltering1543263unfaltering
waitering13310713_waitering
watering122316313_wa_tering
weathering1798353weathering
westering132112643we_stering
yattering132410443_yattering

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.406440125.6
2DLD Change Limit1406031236.04623255.5
3Display Results1231230.0631952.4
 (SQL Overall)1786911236.51527427.6
 
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.