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

106 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
restabling133765(None) 
resailing103314252res_ailing
rescaling122212012resca_ling
resealing102115672resea_ling
resembling1544732resembling
restacking1737182restacking
restaffing1744192restaffing
restaging112410852resta_ging
restamping1565212restamping
restarting11310662restarting
restating102319412resta_ting
restyling1337922rest_yling
retailing103214732re_tailing
stabling112913652__stabling
destaining1267943destaining
detailing112510413de_tailing
disabling1337753dis_abling
enabling1138603_e_nabling
entailing1039393_entailing
establish1444743_establish
estating92614993_esta_ting
forestalling1653633forestalling
gestating11229983gesta_ting
installing1146403installing
metaling111613723me_ta_ling
metalling1249593me_talling
nestling958893nest__ling
pestling111010253pest__ling
prestamping1863653prestamping
reassailing1244103reassailing
reavailing1444873reavailing
recalling122211903re_calling
recoaling121312453recoa_ling
redialing11311843redia_ling
redialling1246203redialling
redoubling1443433redoubling
reestablish1653103reestablish
refalling132010423re_falling
regaling10315363re_ga_ling
rehabbing1733653re_habbing
reinstalling1373393reinstalling
relabeling1344193re_labeling
remailing122412473re_mailing
renailing102813333re_nailing
repealing122513543repea_ling
resaddling1343503resaddling
resampling1544333resampling
resawing122311433res_a_wing
resaying122512453res_a_ying
reseating102421533resea_ting
reselling102213833res_elling
resettling1135893resettling
reshaping1557743resha_ping
reshaving1657273resha_ving
resiling93520173res__iling
reslating102516993resla_ting
resoaking1439373resoa_king
resoling92916303res__oling
resorbing1269353resorb_ing
respacing1438893respa_cing
respading1338803respa_ding
respelling1347973respelling
respooling1355743respooling
restabilize2265343restabilize
restabilizing2553773restabilizing
restable101618443restabl__e
restabled12148953restabl_ed
restables111511423restabl_es
resting85031183rest___ing
restocking1745703restocking
restoking1438193rest_oking
restoring10314613rest_oring
restraining1247533restraining
restriking1548043restriking
restring91518783rest__ring
restriving1448133restriving
restudying1543423restudying
restuffing1743163restuffing
retacking1658973re_tacking
retackling1744433re_tackling
retagging1236033re_tagging
retailings11265233re_tailings
retaining102114733re_taining
retaking133114283re_ta_king
retallying1464703re_tallying
retaping113012553re_ta_ping
retarding111110653re_tarding
retasting102513413re_tasting
retaxing162311333re_ta_xing
retelling102112493re_telling
retiling93319483re_t_iling
retitling1039773re_titling
retooling1039093re_tooling
retotaling1186883retota_ling
retotalling1244043retotalling
revealing132611883revea_ling
rustling9249983rust__ling
stabbing13238763__stabbing
stablings12256103__stablings
staling83925423__sta_ling
stalling95116703__stalling
stapling112813153__stapling
starling93017123__starling
tabling103216033___tabling
vestibuling1752073vestibuling
wrestling1336063wrest__ling

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.406440125.6
2DLD Change Limit1406031066.62621219.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.07825246.0
 
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.