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 “frees” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

280 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
frees8613139(None) 
brees75632551brees
drees65628521drees
fees76450601f_ees
feres86038181feres
flees85828751flees
free75940181free_
freed95223541freed
freer86021241freer
freers94717301freers
freest95318281freest
freres94716171freres
frets85523401frets
fries85535601fries
froes86126691froes
grees65132471grees
prees75937171prees
rees45364191_rees
trees55835761trees
afreet9315152afreet
afreets1037012afreets
agrees74915322agrees
akees96119242akees
areas55935772areas
arenes64928392arenes
ares45871022ar_es
aretes64425352aretes
arles56735742arles
arses55733872arses
bees65453382_bees
braes75735052braes
bredes94818472bredes
bree67241262bree_
breed85526692breed
breeds94914882breeds
breeks125310792breeks
brens75823362brens
breves115516422breves
brews105617072brews
bries74942152bries
cees65941592_cees
ceres75540012ceres
creds85418772creds
creed85727392creed
creeds94714772creeds
creek114917392creek
creeks124812922creeks
creel75121482creel
creels84416942creels
creep95218102creep
creeps104213622creeps
creese84014332creese
creesh11328332creesh
cremes104517992cremes
crepes105419342crepes
cress75022832cress
crews105917502crews
cries75438402cries
dees56356632_dees
dree56638322dree_
dreed75222842dreed
dregs76114862dregs
dreks105714752dreks
dress65319832dress
dries64733672dries
epees75219832epees
ernes55224812ernes
erses55826802erses
faces106439432faces
fades94932862fades
faeces114713122faeces
fakes126032482fakes
fames105735922fames
fanes84639892fanes
farces115223322farces
farers95924052farers
fares85852872fares
farles96025782farles
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
feces105625362feces
feds85234312f_eds
fee66862012f_ee_
feeb96924542f_eeb
feebs106112682feebs
feed84538902f_eed
feeds94921142feeds
feel75233842f_eel
feels85223042feels
feet75352212f_eet
feezes184412612feezes
fehs106522382f_ehs
femes105626222femes
fems96428702f_ems
fens76139762f_ens
fere76342232fere_
ferns85220082ferns
fes66551672f__es
fess76529162f_ess
fetes85630142fetes
fets75345942f_ets
feus75830752f_eus
fezes175220022fezes
fices106031162fices
fiefs116213702fiefs
fifes114822392fifes
files85441272files
fines86644262fines
firers94922682firers
fires85740752fires
fives116027362fives
fixes154723592fixes
fleas86423662fleas
flee76238792flee_
fleer86020772fleer
fleers96015792fleers
fleet85932332fleet
fleets96915062fleets
flews115316442flews
flexes164512952flexes
fleys117015602fleys
flies85630712flies
floes85528142floes
flues84626922flues
foes76543442f_oes
forces114422132forces
fores85847102fores
forges105024262forges
formes114623712formes
fortes95327182fortes
foxes156321092foxes
frae75330472frae_
frags96322172frags
frames115119862frames
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
freak125115242freak
freaks134713062freaks
freely12310962freely
freesia1046322freesia
freeze18349512freeze
freezes193310352freezes
fremd115010322fremd
frena85915272frena
frere85617722frere
fresh115012202fresh
freshes133515822freshes
fret75845042fr_et
fried95322912fried
frier85225842frier
friers94718932friers
friezes19418912friezes
friges104116482friges
frigs96019272frigs
frise85322452frise
frisees104411692frisees
frises94124272frises
frites94922482frites
frits86129102frits
frizes184015462frizes
froe75329992froe_
frogs96220772frogs
frons86124042frons
frows116623102frows
frugs96114282frugs
fryer115913432fryer
fryers125710972fryers
fuels87117352fuels
fumes105224702fumes
furies95126372furies
furzes186613692furzes
fusees95416402fusees
fuses85628422fuses
fuzees184910752fuzees
fuzes175120222fuzes
fyces139813642fyces
fykes156312692fykes
gees55647882_gees
ghees95215552ghees
glees65027592glees
grebes93813612grebes
gree56641562gree_
greed75125692greed
greeds84314282greeds
greek105915942greek
green65522142green
greens75716872greens
greet65835322greet
greets75117422greets
greys96614852greys
grues65721962grues
heres86245902heres
hirees95117292hirees
ires45639282ir_es
jees115938542_jees
knees95114872knees
kreep114610412kreep
kreeps12427412kreeps
krewes1337922krewes
larees65323112larees
lees45455882_lees
meres75143572meres
ogees65119142ogees
ores46056682or_es
orles55326212orles
pees65257372_pees
peres76246642peres
pree67044732pree_
preed85128122preed
preen75925052preen
preens85020112preens
preps96220692preps
prese75228382prese
press75425952press
prexes154915952prexes
preys105717782preys
prezes173614692prezes
pries74339532pries
purees84721682purees
rebs65733562_rebs
recs65734182_recs
redes65139132_redes
reds56042862_reds
ree37974072_ree_
reed55549622_reed
reeds65430902_reeds
reef74938212_reef
reefs85121662_reefs
reek85232522_reek
reeks94124032_reeks
reel45240532_reel
reels55333262_reels
reest54938092_reest
refs75732242_refs
reges65628792_reges
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_r_es
rets45352562_rets
revs75027052_revs
rexes124526952_rexes
roes45954142_roes
rues46044482_rues
ryes75529352_ryes
sarees65329942sarees
screes85023972screes
sees45361052_sees
seres55448892seres
sirees64624582sirees
skees95023122skees
sprees85620642sprees
tees45353582_tees
threes97117322threes
tree47745812tree_
treed65626732treed
treen55622752treen
treens65317872treens
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tries55742812tries
trues54925322trues
tyees86019452tyees
unfrees1048642unfrees
ureas55826012ureas
urges64619912urges
vees75439432_vees
wees76249122_wees
wrens85016242wrens
wries85827742wries
zees136331892_zees

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538002801.37339184.3
3Display Results2802800.0763684.2
 (SQL Overall)1786912801.762101413.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.