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

101 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
reteaching163602(None) 
detaching1637262det_aching
reaching143317202r__eaching
reattaching1743122reattaching
researching1743422researching
retacking1658972ret_acking
retching143412172ret__ching
reteaming122110442retea_ming
retearing102214252retea_ring
retouching1644692retouching
retracing12313292retrac_ing
retracking1738162retracking
retracting13311932retracting
retrenching1743922retrenching
teaching143612602__teaching
unteaching1645492unteaching
attaching1545433_attaching
beaching164114143__beaching
beseeching1843363beseeching
bleaching17287093_bleaching
breaching17269403_breaching
breeching17236473bre_e_ching
detecting13259983dete_cting
dethatching2142243dethatching
detracting1438713detracting
etching134511843_et__ching
fetching17298413fet__ching
forereaching2151953forereaching
impeaching2043373impeaching
leaching143012833__leaching
leeching14318373le_e_ching
letching143810263let__ching
misteaching1944533misteaching
nonteaching1753583nonteaching
outreaching1744913outreaching
overteaching2174923overteaching
peaching163613643__peaching
pleaching17257083_pleaching
preaching172811163_preaching
reacting113317893r__eacting
reattacking1843303reattacking
rebranching1943383rebranching
redacting13612303re_dacting
reearning1039053re_earning
reechoing1545293re_e_choing
reenacting1357353reenacting
refacing142512813re_fac_ing
refecting152413353refe_cting
refencing15188853refenc_ing
refracting1638733refracting
regearing112211413regea_ring
rehashing1647113re_hashing
rehearing132211763rehea_ring
rehearsing1444343rehearsing
reheating132314913rehea_ting
rejecting192211153reje_cting
relacing112516043re_lac_ing
relearning1135283relearning
releasing10411013relea_sing
rematching1844913rematching
repacking1838283re_packing
repatching1844993repatching
repealing122513543repea_ling
repeating122618983repea_ting
replacing142210163replac_ing
reproaching1944303reproaching
reracking1639313re_racking
rereading111212713rerea_ding
resealing102115673resea_ling
reseating102421533resea_ting
resecting122816483rese_cting
resketching2142273resketching
respacing1438893respac_ing
restacking1737183restacking
restitching1744003restitching
restretching1852893restretching
retackling1744433ret_ackling
retagging1236033ret_agging
retailing103214733ret_ailing
retaining102114733ret_aining
retaking133114283ret_a_king
retaping113012553ret_a_ping
retarding111110653ret_arding
retasting102513413ret_asting
retaxing162311333ret_a_xing
reteach1237413reteach___
reteaches1437123reteach_es
retelling102112493rete_lling
retesting102614603rete_sting
retraining11310243retraining
retreading12128483retrea_ding
retreating111414773retrea_ting
retroacting1447283retroacting
revealing132611883revea_ling
rewashing1676903re_washing
rewearing132310703rewea_ring
reweaving16227073rewea_ving
reweighing1852963reweighing
roaching143210433r__oaching
teachings15296553__teachings
upreaching1844113upreaching

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.420425454.8
2DLD Change Limit1406031016.03323305.7
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.49927495.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.