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

250 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
unreels725831(None) 
unreel63612931unreel_
creels84416942_creels
kneels10408932kn_eels
reels55333262__reels
streels73811342streels
unfrees1048642unfree_s
unlevels1143802unlevels
unravels1144632unravels
unreal64414452unreal_
unreeled91310332unreeled
unreeler8127292unreeler
unreelers9154742unreelers
unreeve10176762unreeve
unreeves11106162unreeves
unrests7229462unrests
unrolls797792unrolls
unseals73212572unseals
unsells73210772unsells
unsteels845792unsteels
unveils1045752unveils
afreets1037013afreets
agrees74915323agree_s
aneles64626293an_eles
angels74416173an_gels
anneals7449943anneals
ariels65119373_ariels
artels66216233_artels
barbels114514433barbels
barrels94514363barrels
bordels103911973bordels
boreens9310403boreens
breeds94914883_breeds
breeks125310793_breeks
brees75632553_bree_s
bungees104513103bungee_s
carcels114516063carcels
careens94514703careens
careers95218783careers
carpels115315463carpels
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
cereals9313173cereals
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
creeds94714773_creeds
creeks124812923_creeks
creel75121483_creel_
creeps104213623_creeps
crenels93711013_crenels
crewels12438493_crewels
darnels83710433darnels
dorsels84412573dorsels
drees65628523_dree_s
eels46536743___eels
enamels9128163enamels
enrolls7108093enrolls
enrols61213383enr_ols
entrees71813773entree_s
enwheels1442853enwheels
fardels11389893fardels
farfels13348213farfels
feels85223043__feels
ferrels10248623ferrels
freely12310963_freely
freers94717303_freers
frees86131393_free_s
funerals1146453funerals
funnels10348173fun_nels
greeds84314283_greeds
greens75716873_greens
grees65132473_gree_s
greets75117423_greets
gruels73910153_gruels
gunnels8358563gun_nels
gunsels8338133gun_sels
hareems12428203hareems
heels85625533__heels
hirees95117293hiree_s
hirsels10128343hirsels
inbreeds11234623inbreeds
jereeds15326393jereeds
jurels133710583jur_els
keels94622413__keels
kernels11417953kernels
knawels14344683knawels
kneel95012033kn_eel_
knees95114873kn_ee_s
knells10439253kn_ells
kreeps12427413_kreeps
larees65323113laree_s
lungees84412143lungee_s
marcels113212373marcels
marvels123810093marvels
moreens939963moreens
morels84820013mor_els
morsels94112653morsels
navels95712693_navels
needs65719633_n_eeds
neems77316293_n_eems
neeps75617883_n_eeps
nereis6315343_nereis
nerols6914883_nerols
newels93710823_newels
noels56418703_n_oels
novels95512503_novels
nurls55519683nur__ls
nursers74311833nursers
nurses63919353nurse_s
oriels64914623_oriels
outfeels1135063outfeels
parcels113712663parcels
parrels94713493parrels
peels75226423__peels
preens85020113_preens
prees75937173_pree_s
pugrees10218523pugree_s
purees84721683puree_s
quarrels1735083quarrels
reals55038653__reals
rebels84518133__rebels
reeds65430903__reeds
reefs85121663__reefs
reeks94124033__reeks
reel45240533__reel_
rees45364193__ree_s
refeels10379693refeels
refels94618053__refels
reheels10298253reheels
repels84318763__repels
revels94220573__revels
riels55121333__riels
runnels7329153run_nels
sarees65329943saree_s
screeds106210293screeds
screens95212183screens
screes85023973scree_s
seels55632823__seels
sirees64624583siree_s
sneers64016173sn_eers
snells64614203sn_ells
snivels10336903snivels
snorkels1234413snorkels
sorels63921163sor_els
sorrels7310723sorrels
speels85116393_speels
sprees85620643spree_s
steels64117983_steels
streeks11378713streeks
streel64214023streel_
streets73312613streets
teels55726373__teels
tercels94110363tercels
threeps12687043threeps
threes97117323three_s
treens65317873_treens
trees55835763_tree_s
tunnels7328723tun_nels
tureens7289873tureens
umbels104510593u_mbels
unbales92914863unbales
unbears998043unbears
unbelt83015693un_belt
unbelts9237663unbelts
unbends10236993unbends
unbreech1542233unbreech
uncials92510523uncials
uncles8317163uncle_s
uncoils979533uncoils
uncurls937123uncurls
undee65327273undee__
undies73821963undie_s
undoers82910583undoers
undoes73917403undoe_s
undress838893undress
unfelt92413463un_felt
unfree9413203unfree__
unfreed11510123unfree_d
unfreeze2043343unfreeze
unfreezes2142533unfreezes
unfurls1035573unfurls
ungreedy1342813ungreedy
ungues7412123ungue_s
unhelm1136863un_helm
unhelms1234223unhelms
uniters73814173uniters
unites65024853unite_s
unkeeled13117183unkeeled
unkennels1342573unkennels
unleads8228623unleads
unless62413073un_less
unlevel1035913unlevel_
unmeet83815743unmee_t
unmeetly1344073unmeetly
unmews11326523un_mews
unnails738223unnails
unpeeled11118533unpeeled
unpegs9256233un_pegs
unpens82511013un_pens
unpiles92112783unpiles
unravel1038063unravel_
unread73412673unr_ead
unready11215943unready
unreally1148233unreally
unreeling1038983unreeling
unreeved12117673unreeved
unrent63219783unr_ent
unrest62918853unr_est
unrigs7159003unr_igs
unripely1344633unripely
unrips8199453unr_ips
unrobes9269733unrobes
unroll61210073unr_oll
unroofs1035783unroofs
unroots738563unroots
unruled8311373unruled
unruly938083unr_uly
unseal63315473unseal_
unseams9338913unseams
unseats73012853unseats
unseemly1343763unseemly
unseen62012623unsee_n
unsell63512543un_sell
unsets64116163un_sets
unsews9379363un_sews
unsexes14248923unsexes
unshell1047113unshell
unshells1145923unshells
unsteel738793unsteel_
unsteps936213unsteps
unties64326923untie_s
untreads936223untreads
unveil957343unveil_
unwell9349443un_well
upkeeps1532193upkeeps
uprears9107493uprears
upwells12244303upwells
uraeus638793u_raeus
ureal56722683u_real_
ureas55826013u_r_eas
uredos73910623u_redos
ureters7311823u_reters
urgers73313623u_rgers
urges64619913u_rge_s
urials64415193u_rials
vakeels14113733vakeels
wheels123811713_wheels
wurzels1934083wurzels

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272506.17321711.8
3Display Results2502500.0763289.5
 (SQL Overall)1786912506.65526850.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.