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

104 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
relearning113528(None) 
reearning1039051re_earning
learning978552__learning
recleaning1336752reclea_ning
regearing112211412regear_ing
rehearing132211762rehear_ing
rehearsing1444342rehearsing
releasing10411012relea_sing
reloaning10710482reloa_ning
retearing102214252retear_ing
rewearing132310702rewear_ing
unlearning1144712unlearning
beleaping1436743belea_ping
bemeaning1436193bemea_ning
bewearying1942293bewearying
blearing113111943_blear_ing
cellaring1238523cellar_ing
cleaning113112383_clea_ning
clearing113014883_clear_ing
clearwing1533673_clearwing
debearding1543733debearding
decerning1337293dece_rning
deleading1237773delea_ding
deleaving1436263delea_ving
demeaning1337243demea_ning
earning83418213___earning
gleaning10269323_glea_ning
leaning83721203__lea_ning
learnings1094323__learnings
mislearning1443723mislearning
nonearning1145183nonearning
outearning1146743outearning
outlearning1243543outlearning
overlearning1644713overlearning
precleaning1644263preclea_ning
preclearing1645103preclear_ing
prewarning16135193pre_warning
preweaning1645633prewea_ning
readorning1245723readorning
rearing83128783r__ear_ing
rearming111413613r__earming
reboarding1445673reboarding
recaning111416693re_ca_ning
recharging1745293recharging
recharting1637213recharting
redefining1545423redefining
referring1338033refe_rring
refraining1437263refraining
regaining112411083re_gaining
regarding12149153re_garding
rehearings14214573rehear_ings
reheating132314913rehea_ting
relacing112516043rel_a_cing
relanding112110923rel_anding
relapsing1236843rel_apsing
relating92725443rel_a_ting
relaxing162612633rel_a_xing
relaying122515153rel_a_ying
relearn747973relear__n_
relearned1035633relearn_ed
relearns836303relear__ns
relearnt849213relear__nt
relegating1239483relegating
relending112412023rele_nding
relenting102716773rele_nting
reletting102713943rele_tting
relining93218743rel__ining
reloading1189883reloa_ding
relumining1345643relumining
remaining122212793re_maining
remanning12229033re_manning
remarking1638893re_marking
remerging1358323reme_rging
reparking1638923re_parking
repealing122513543repea_ling
repeating122618983repea_ting
reperking1638703repe_rking
replanning1345313replanning
repleading1436623replea_ding
replevining1743153replevining
rereading111212713rerea_ding
resealing102115673resea_ling
researching1743423researching
reseasoning1243003reseasoning
reseating102421533resea_ting
reserving131110643rese_rving
restarting11310663restarting
retaining102114733re_taining
retarding111110653re_tarding
reteaching1636023reteaching
reteaming122110443retea_ming
retraining11310243retraining
returning1038133re_turning
revealing132611883revea_ling
reverbing15248593reve_rbing
revering122918073reve_r_ing
reversing132611483reve_rsing
reverting132315133reve_rting
rewarding14148833re_warding
rewarming15147383re_warming
reweaving16227073rewea_ving
rezeroing1935933reze_roing
secerning1246203sece_rning
yearning1296983__yearning

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 Filter1786911406030.436409841.7
2DLD Change Limit1406031046.97020172.6
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.45223978.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.