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 “refraining” 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
refraining143726(None) 
retraining11310241retraining
detraining1267672detraining
pretraining1446502pretraining
refining122416862ref__ining
refracting1638732refracting
reframing1538622refra_ming
regaining112411082re_gaining
remaining122212792re_maining
reordaining1343452reordaining
reraising10313772re_raising
restraining1247532restraining
retaining102114732re_taining
befringing1744063befr_inging
braining113414683__braining
defining133711803def__ining
defragging1742823defragging
defrauding1642923defrauding
defraying1735853defra_ying
deraigning1344103de_raigning
derailing112011313de_railing
destaining1267943destaining
detaining112510473de_taining
draining103312673__draining
engraining1245223engraining
entraining1147643entraining
graining102813183__graining
hebraizing2545113hebraizing
ingraining1245623ingraining
pertaining1347993pertaining
prefranking2143313prefranking
preordaining1652513preordaining
raining83922693___raining
reattaining1244593reattaining
reavailing1444873reavailing
rebaiting12311643re_baiting
recaning111416693re_ca_ning
reclaiming1546583reclaiming
reclining121112283re_clining
recoining121313803re_coining
recrating121318793recra_ting
recrowning1645213recrowning
recruiting1347903recruiting
redbaiting1446263redbaiting
redefining1545423redefining
redlining111210293re_dlining
redrafting1545963redrafting
redrawing1437213redra_wing
redriving1437603redr_iving
reearning1039053re_earning
reexamining2152663reexamining
refacing142512813ref_a_cing
refalling132010423ref_alling
refiling123116533ref__iling
refinding14259943ref__inding
refiring123513923ref__iring
refixing19329793ref__ixing
reflagging1643483reflagging
reflating132514713refla_ting
refrain10310043refra__in_
refrained1347223refrain_ed
refrainer1245843refrain_er
refrainers1344473refrainers
refrainment1654483refrainment
refrains1139593refra__ins
refreezing2344413refreezing
refreshing1746063refreshing
refronting1437273refronting
refrying15278903refr__ying
regrading121210203regra_ding
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regra_ting
regreening1246033regreening
regrinding1335703regr_inding
reimagining1542663reimagining
reining84425323re___ining
rejoining17149223re_joining
relearning1135283relearning
relining93218743re__lining
reloaning10710483reloa_ning
relumining1345643relumining
remailing122412473re_mailing
remanning12229033re_manning
renailing102813333re_nailing
reobtaining1443533reobtaining
repainting13128973re_painting
repairing12310013re_pairing
repining114116593re__pining
replanning1345313replanning
repricing14310473repr_icing
reprinting131510583repr_inting
reprising12312553repr_ising
reracking1639313re_racking
rerising93017783re_r_ising
rerunning1036523re_running
resailing103314253re_sailing
reshining13310743re_shining
resining92919553re__sining
retailing103214733re_tailing
retracing12313293retra_cing
retracking1738163retracking
retracting13311933retracting
rewrapping1843343rewrapping
rewriting13310413rewr_iting
spraining1248153_spraining
straining10410563_straining
training93015863__training

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 Limit1406031086.25022496.5
3Display Results1081080.0631714.3
 (SQL Overall)1786911086.71926594.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.