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

155 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
refronts113777(None) 
refront10313261refront_
affronts1444162affronts
defrosts1244832defrosts
forefronts1643522forefronts
fronts94415792__fronts
redroots937752redroots
referents12259642referents
refloats1156912refloats
refracts13137382refracts
refronted1336052refronted
regrants9310012regrants
reprints1039902reprints
rerents73319422re_rents
seafronts1244382seafronts
affront1357963affront_
befrets1237613befr_ets
breakfronts2051693breakfronts
confronts1447063confronts
creodonts1243963creodonts
deferents13269393deferents
defrocks1844113defrocks
defrost1139553defrost_
efforts1334703_efforts
enroots738713_enroots
errants7410643_errants
fonts86124753__f_onts
forefront1546493forefront_
fronds106412343__fronds
frons86124043__fron_s
front85029223__front_
frontes104214163__frontes
frosts94214623__frosts
gerents82612923ge_rents
herons94820543he_ron_s
lakefronts1751543lakefronts
negronis947263negronis
neurones839673neurones
neurons7410443neuron_s
oreodonts1043683oreodonts
perrons93115483perron_s
prefranks1862993prefranks
prefrontal1552603prefrontal
prefrontals1651523prefrontals
preprints1347473preprints
readopts1146493readopts
readouts938903readouts
reagents959623reagents
reanoints945363reanoints
reasons72514943reason_s
reboots93512093re_boots
recants93217093re_cants
reckons13269653reckon_s
recoats92616643re_coats
recons84922993re_con_s
recounts1038773recounts
recreants1146623recreants
recross989833recro_ss
recrowns13246143recrowns
recruits1036563recruits
redbones1137593redbones
redcoats1147123redcoats
redons75222183re_don_s
redouts81411663re_douts
redrafts1235603redrafts
redroot8312903redroot_
reerects10319923reerects
refects124012743ref_ects
referent112813423referent_
refights1555883refights
refinds114512123ref_inds
refines105426343ref_ines
refits94017653ref__its
reflects13288873reflects
reflets103513153ref_lets
refloat10310833refloat_
refloods1245553refloods
reflows13258983reflo_ws
refocus1236973ref_ocus
refolds11298953ref_olds
reforest1139963reforest
reforests1245533reforests
reforges12249333reforges
reformats1445713reformats
reforms1239813ref_orms
refounds1255733refounds
refract121311603refract_
refrains1139593refrains
reframes1338993reframes
refries104419733refr_ies
refronting1437273refronting
refroze1956223refro_ze
refrozen2063873refrozen
refunds11448623ref_unds
regents83416543re_gents
regions83613473region_s
regrafts1235303regrafts
regrant8317323regrant_
regreets9287853regreets
regrets83212923regr_ets
regrinds1035533regrinds
regrooms1196013regrooms
regroups11104383regroups
regrows11269153regro_ws
regrowth1544033regrowth
regrowths1642433regrowths
reknots1136783rekno_ts
relents74018503re_lents
remints95117293re_mints
remnants1036843remnants
remounts1036373remounts
rents55935183re___nts
reorients997363reorients
repaints1038483repaints
repents93717623re_pents
replants102811243replants
replots93412633replo_ts
reports94916213re_ports
repots85621003re_po_ts
reprint9318983reprint_
reprobes121910293reprobes
reproofs1346063reproofs
repros84216003repro__s
reproves132011473reproves
rerent63832453re_rent_
rerolls739943re_rolls
reroofs1037943re_roofs
reroute7313963re_route
reroutes8312223re_routes
reruns66413743re_run_s
resents74221223re_sents
reshoots11228413reshoots
resorts74817193re_sorts
responds1136913responds
respots92912763respo_ts
resprouts1174823resprouts
retints74717013re_tints
retirants947323retirants
retorts76016513re_torts
retracts101111313retracts
retreats8311413retreats
retroacts1146283retroacts
retrofits1245353retrofits
retronym1354683retronym
retronyms1444193retronyms
retros63820193retro__s
revolts1038893re_volts
rewrote1039113rewro_te
rezones163213943re_zones
riverfronts1751233riverfronts
seafront1148023seafront_
shorefronts1751683shorefronts
storefronts1451763storefronts
teflons1036543teflon_s
upfront1246973upfront_

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621556.29623215.1
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.51527427.6
 
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.