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 “refronted” 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
refronted133606(None) 
affronted1642502affronted
defrosted1444262defrosted
fronted114011272__fronted
refloated1347012refloated
refracted1557392refracted
refront10313262refront__
refronts1137772refront_s
regranted1137702regranted
reprinted1289042reprinted
rerented92516162re_rented
rerouted9311152re_routed
befretted1544373befretted
befringed16123863befringed
confronted1644193confronted
defrocked2043063defrocked
defroster1343903defroster
enrooted977433_enrooted
fronded12388863__fronded
fronter103611583__fronter
frontes104214163__frontes
frosted113211883__frosted
prefranked2042773prefranked
prefrontal1552603prefrontal
preprinted1546543preprinted
readopted1344923readopted
reanointed1144553reanointed
rearoused1047103rearoused
reasoned9410733reason_ed
rebooted11248463re_booted
recanted112513513re_canted
reckoned1546963reckon_ed
recoated113416793re_coated
reconned113610663re_conned
recounted1238723recounted
recrated112918613recr_ated
recreated12412543recreated
recrossed1246523recrossed
recrowned1564863recrowned
recruited1236463recruited
redonned10297103re_donned
redrafted1435143redrafted
reerected1238613reerected
refected142311663ref_ected
refenced1439003ref_enced
referenced1676863referenced
refined114720003ref_in_ed
refitted12309413ref_itted
reflated123514293ref_lated
reflected1547983reflected
reflooded1443553reflooded
reflowed15126913reflo_wed
refolded1337063ref_olded
reforested1445393reforested
reforged13268703ref_orged
reformed14249603ref_ormed
refounded1435473refounded
refrained1347223refrained
reframed1437853refr_amed
refreshed1685623refreshed
refried113513883refr__ied
refronting1437273refronting
refroze1956223refro_ze_
refrozen2063873refro_zen
refunded1336953ref_unded
refuted114313803ref__uted
regrafted1435243regrafted
regrated102816333regr_ated
regreeted1136173regreeted
regretted1137233regretted
regroomed1344163regroomed
regrooved1443263regrooved
regrouped1343643regrouped
reknotted1443523reknotted
relented92614943re_lented
reminted113615083re_minted
remounted1236283remounted
rented74426593re___nted
reoriented1145343reoriented
repainted1277863repainted
repented112614983re_pented
replanted1248063replanted
replotted1235823replotted
reported11312703re_ported
repotted1139283re_potted
reprinter1197353reprinter
reprobated1546393reprobated
reprobed13228753repro_bed
reproved14199483repro_ved
rerolled93010063re_rolled
reroofed1235883re_roofed
reroute7313963re_route_
reroutes8312223re_routes
resented92716963re_sented
resonated10510613re_sonated
resorted9313493re_sorted
responded1336513responded
respotted1235953respotted
resprouted1344223resprouted
retinted94414363re_tinted
retorted9312333re_torted
retracted12410953retracted
retreated10312633retreated
retroacted1366143retroacted
revolted12319863re_volted
revoted114314153re_vo_ted
rewrote1039123rewro_te_
rezoned173611163re_zon_ed

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411087.12320867.8
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.59223536.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.