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

142 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
refracting163873(None) 
retracting13311931retracting
detracting1438712detracting
infracting1647352infracting
reacting113317892re__acting
recrating121318792recra_ting
redacting13612302re_dacting
redrafting1545962redrafting
reenacting1357352reenacting
reerecting1339972reerecting
refacing142512812ref_ac_ing
refecting152413352ref_ecting
reflating132514712refla_ting
reflecting1638822reflecting
refractile1544142refractile
refraction15137902refraction
refractions16127722refractions
refractive1846692refractive
refraining1437262refraining
reframing1538622refra_ming
refronting1437272refronting
regrafting1545992regrafting
regranting1238322regranting
regrating111316212regra_ting
reracking1639312re_racking
retracing12313292retrac_ing
retracking1738162retracking
retroacting1447282retroacting
aerating92821003ae_ra_ting
attracting1346563attracting
befretting1644793befretting
berating113220763be_ra_ting
defacing15238683def_ac_ing
defatting1436103def_atting
defeating142311973defea_ting
defecating17237783defecating
defecting162510223def_ecting
deflating142610713defla_ting
deflecting1736503deflecting
defragging1742823defragging
defrauding1642923defrauding
defraying1735853defra_ying
defrocking2143153defrocking
defrosting1544493defrosting
derating103222283de_ra_ting
deratting1139513de_ratting
diffracting2143343diffracting
effacing1744463_effac_ing
effecting1845583_effecting
enacting11311363_e_nacting
erecting112415063_e_recting
eructing112110173_e_ructing
exacting1838523_e_xacting
extracting2047223extracting
overacting16310913overacting
perfecting1847513perfecting
preacting142412533pre__acting
preenacting16125373preenacting
preerecting1646143preerecting
prefacing17118743pref_ac_ing
prefranking2143313prefranking
protracting1646933protracting
reaching143317203re__aching
readapting1445153readapting
rebaiting12311643re_baiting
rebating112418343re_ba_ting
rebranching1943383rebranching
recanting122414823re_canting
recasting122414233re_casting
recharting1637213recharting
recoating121317463recoa_ting
recreating131214583recreating
recruiting1347903recruiting
redating102620173re_da_ting
redbaiting1446263redbaiting
redirecting1545613redirecting
redrawing1437213redra_wing
reejecting2045813reejecting
reelecting1338783reelecting
refalling132010423ref_alling
refencing15188853refenc_ing
refighting1845203refighting
refitting132811123ref_itting
reflagging1643473reflagging
refloating14198323refloating
reforesting1546193reforesting
reformatting1852703reformatting
refract121311603refract___
refracted1557393refract_ed
refractor14156323refract_or
refractors15156273refractors
refractory18134773refractory
refracts13137383refract__s
refrain10310043refra__in_
refrains1139593refra__ins
refreezing2344413refreezing
refreshing1746063refreshing
refrying15278903refr__ying
refuting121911903ref__uting
regrading121210203regra_ding
regreeting1237343regreeting
regretting1237783regretting
reheating132314913rehea_ting
rejecting192211153re_jecting
relacing112516043re_lac_ing
relating92725443re_la_ting
relocating13310873relocating
relucting1239773re_lucting
remating112322413re_ma_ting
repacking1838283re_packing
repasting122312843re_pasting
repeating122618983repea_ting
replacing142210163replac_ing
replanting1338523replanting
replating122217403repla_ting
repricing14310473repric_ing
reprinting131510583reprinting
reproaching1944303reproaching
reraising10313773re_raising
rerenting102617663re_renting
rerouting10311873re_routing
reseating102421533resea_ting
resecting122816483re_secting
reslating102516993resla_ting
respacing1438893respac_ing
respecting1549883respecting
restacking1737183restacking
restarting11310663restarting
restating102319413resta_ting
restricting1449303restricting
retacking1658973re_tacking
retasting102513413re_tasting
reteaching1636023reteaching
retractile1246253retractile
retraction121310533retraction
retractions13910353retractions
retraining11310243retraining
retreating111414773retreating
rewrapping1843343rewrapping
rewriting13310413rewr_iting
serrating10513203serra_ting
terracing1237703terrac_ing

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.423422437.4
2DLD Change Limit1406031425.89023871.5
3Display Results1421420.0602366.7
 (SQL Overall)1786911426.37328038.8
 
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.