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

201 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
refront1031326(None) 
refronts1137771refronts
affront1357962affront
defrost1139552defrost
forefront1546492forefront
front85029222__front
redroot8312902redroot
referent112813422referent
refloat10310832refloat
refract121311602refract
refronted1336062refronted
refroze1956222refroze
regrant8317322regrant
reprint9318982reprint
rerent63832452re_rent
seafront1148022seafront
upfront1246972upfront
affronts1444163affronts
befret11315963befr_et
bowfront1644723bowfront
breakfront1952683breakfront
confront13411603confront
creodont1147693creodont
deferent122712873deferent
defiant11311923defiant
defrock1744643defrock
defrosts1244833defrosts
effort1238623_effort
enroot6615993_enroot
errant6618733_errant
font77143753__f_ont
forefronts1643523forefronts
frond95316343__frond
frons86124043__frons
fronts94415793__fronts
frost84727833__frost
gerent73223103ge_rent
heron85025503he_ron_
herons94820543he_rons
lakefront1653343lakefront
learnt64019253lear_nt
negroni846843negroni
neuron6310373neuron_
neurone739443neurone
neurons7410453neurons
oreodont947603oreodont
perron83216623perron_
perrons93115483perrons
prefrank1764233prefrank
prefrontal1552603prefrontal
prefroze2264673prefroze
preprint12314183preprint
readopt10410843readopt
readout8615513readout
reagent8716603reagent
reanoint8413013reanoint
rearing83128783rearing
rearmost1047263rearmost
reason62616333reason_
reasons72514943reasons
reblent9614253reblent
reboant9315093reboant
reboot84119333re_boot
reborn810016963reborn_
recant83228683re_cant
recent83630853re_cent
reckon123010543reckon_
reckons13269653reckons
recoat84024273re_coat
recon75624243re_con_
recons84922993re_cons
recount9315173recount
recreant10311283recreant
recross989843recross
recrown12257573recrown
recrowns13246143recrowns
recruit939773recruit
redbone1037973redbone
redcoat10410883redcoat
redon65424883re_don_
redone74820053re_done
redons75222183re_dons
redout71820253re_dout
redraft11310573redraft
redroots937753redroots
redrove11249423redrove
reerect92915883reerect
refect114319333ref_ect
refelt94521423ref_elt
referents12259643referents
reffing143712173reffing
refight1488873refight
refind104717073ref_ind
refine95225693ref_ine
refiring123513923refiring
refit84230063ref__it
reflect123913713reflect
reflet94024233ref_let
refloats1156913refloats
reflood1136363reflood
reflow12379653reflo_w
reflown13316213reflown
reflows13258983reflows
refluent1147443refluent
refold103812113ref_old
reforest1139963reforest
reforge11259033reforge
reform11312713ref_orm
reformat1357653reformat
reforms1239823reforms
refound1157413refound
refracts13137383refracts
refrain10310043refrain
refrains1139593refrains
reframe1239393reframe
refresh1335453refresh
refried113513883refried
refries104419733refries
refronting1437273refronting
refrozen2063873refrozen
refry114412463refr__y
refrying15278903refrying
reft75141273ref___t
refund104810303ref_und
regent74127673re_gent
region74614903region_
regions83613473regions
regnant8312843regnant
regraft11310153regraft
regrants9310013regrants
regreet83015953regreet
regret73723533regr_et
regrind938983regrind
regroom1077303regroom
reground1045073reground
regroup1095173regroup
regrow10309883regro_w
regrown11237363regrown
regrows11269153regrows
regrowth1544033regrowth
reknot10311733rekno_t
relent64431853re_lent
reliant7319243reliant
remint85329983re_mint
remnant9312643remnant
remount9512283remount
rent46661243re___nt
reorient8613473reorient
repaint9318363repaint
repent84728873re_pent
replant93318533replant
replot83818593replo_t
report85326023re_port
repot75132623re_po_t
reprints1039903reprints
repro75315913repro__
reprobe112310133reprobe
reproof1238783reproof
repros84216003repro_s
reprove122911073reprove
reptant92817073reptant
reran57329103re_ran_
rerents73319423re_rents
reroll6412683re_roll
reroof9315003re_roof
rerose63320853re_rose
reroute7313963re_route
rerun58722153re_run_
reruns66413743re_runs
resent63833623re_sent
reshone102414163reshone
reshoot102513893reshoot
reshot93519633resho_t
resort65728623re_sort
respond1039113respond
respot83117633respo_t
resprout1078783resprout
retint65633443re_tint
retirant8313593retirant
retorn610923433retorn_
retort66831153re_tort
retract91318113retract
retreat7317533retreat
retro55020953retro__
retroact10410003retroact
retrofit1148303retrofit
retronym1354683retronym
retros63820193retro_s
reverent112615093reverent
revolt9316223re_volt
rewon86920583re_won_
reworn98122203reworn_
rewrapt12138113rewrapt
rewrote1039123rewrote
rezone153814783re_zone
riverfront1652153riverfront
seafronts1244383seafronts
shorefront1653383shorefront
storefront1353413storefront
teflon937453teflon_
teflons1036543teflons

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272017.39018136.3
3Display Results2012010.0762644.7
 (SQL Overall)1786912017.87222699.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.