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

105 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
refronting143727(None) 
affronting1742602affronting
defrosting1544492defrosting
fronting12310442__fronting
refloating14198322refloating
refracting1638732refracting
regranting1238322regranting
reprinting131510582reprinting
rerenting102617662re_renting
rerouting10311872re_routing
befretting1644793befretting
befringing1744063befringing
confronting1744863confronting
defrocking2143153defrocking
enrooting10128133_enrooting
frosting12311183__frosting
prefranking2143313prefranking
preprinting1647413preprinting
readopting1465513readopting
reanointing1244993reanointing
rearousing1156453rearousing
reasoning10310203reason_ing
rebooting12139023re_booting
recanting122414823re_canting
reckoning1637643reckon_ing
recoating121317463re_coating
reconning121410793re_conning
recounting1339193recounting
recrating121318793recr_ating
recreating131214583recreating
recrossing1386973recrossing
recrowning1645213recrowning
recruiting1347903recruiting
redonning11127643re_donning
redrafting1545963redrafting
reerecting1339973reerecting
refecting152413353ref_ecting
refencing15188853ref_encing
referencing1744493referencing
refighting1845203refighting
refinding14259943ref_inding
refining122416863ref_in_ing
refitting132811123ref_itting
reflating132514713ref_lating
reflecting1638823reflecting
reflooding1544053reflooding
reflowing1636523reflo_wing
refolding1437453ref_olding
reforesting1546193reforesting
reforging1437663ref_orging
reforming1538563ref_orming
refounding1545353refounding
refraining1437263refraining
reframing1538623refr_aming
refreezing2344413refreezing
refreshing1746063refreshing
refront10313263refront___
refronted1336053refront_ed
refronts1137773refront__s
refrying15278903refr__ying
refunding14258073ref_unding
refuting121911903ref__uting
regrafting1545993regrafting
regrating111316213regr_ating
regreeting1237343regreeting
regretting1237783regretting
regrinding1335703regrinding
regrooming1464163regrooming
regrooving1553503regrooving
regrouping1443693regrouping
regrowing1436673regro_wing
reknotting1564233reknotting
relenting102716773re_lenting
reminting122315103re_minting
remounting1346673remounting
renting84026853re___nting
reorienting1246353reorienting
repainting13128973repainting
repenting122316553re_penting
replanting1338523replanting
replotting1357043replotting
reporting12513903re_porting
repotting12511123re_potting
reprobating1647103reprobating
reprobing1438073repro_bing
reproving1538413repro_ving
rerolling102210373re_rolling
reroofing1336863re_roofing
rerunning1036523re_running
resenting102619293re_senting
reshooting1436223reshooting
resonating11311263re_sonating
resorting10614613re_sorting
responding1437403responding
respotting1347113respotting
resprouting1445053resprouting
retinting102215253re_tinting
retorting10613273re_torting
retracting13311933retracting
retreating111414773retreating
retroacting1447283retroacting
revolting1339633re_volting
revoting12312033re_vo_ting
rewriting13310413rewr_iting
rezoning18310453re_zon_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.500357382.0
2DLD Change Limit1406031055.76624384.8
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.31228309.7
 
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.