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

254 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
flees8582875(None) 
fees76450601f_ees
fleas86423661fleas
flee76238791flee_
fleer86020771fleer
fleers96015791fleers
fleet85932331fleet
fleets96915061fleets
flews115316441flews
flexes164512951flexes
fleys117015601fleys
flies85630711flies
floes85528141floes
flues84626921flues
frees86131391frees
glees65027591glees
lees45455881_lees
akees96119242akees
alecs76620732alecs
alee46652322alee_
alefs87319662alefs
ales47067102al_es
allees64521482allees
almes75126542almes
aloes54933672aloes
bees65453382_bees
blebs96416152blebs
bleed85019802bleed
bleeds95211592bleeds
bleep95013452bleep
bleeps10499102bleeps
bless75917812bless
blets75324942blets
blues75127042blues
brees75632552brees
cees65941592_cees
cleek115514912cleek
cleeks125010542cleeks
clefs106616242clefs
clepes104214622clepes
clews105516332clews
clues74623032clues
dees56356632_dees
deles65139252deles
drees65628522drees
elves85118742elves
epees75219832epees
faces106439432faces
fades94932862fades
faeces114713122faeces
fakes126032482fakes
falces115216002falces
fames105735922fames
fanes84639892fanes
fares85852872fares
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
feces105625362feces
feds85234322f_eds
fee66862012f_ee_
feeb96924542f_eeb
feebs106112682feebs
feed84538902f_eed
feeds94921142feeds
feel75233842f_eel
feels85223042feels
feet75352212f_eet
feezes184412612feezes
fehs106522382f_ehs
fells85327382fells
felts85324542felts
femes105626222femes
fems96428702f_ems
fens76139762f_ens
feres86038182feres
fes66551672f__es
fess76529162f_ess
fetes85630142fetes
fets75345942f_ets
feus75830752f_eus
fezes175220022fezes
fices106031162fices
fiefs116213702fiefs
fifes114822392fifes
filers94623722filers
files85441272files
filets94718952filets
filles94224522filles
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
flabs105818642flabs
flags95321282flags
flakes134118872flakes
flames114723692flames
flams105125012flams
flanes94522422flanes
flans85327972flans
flaps105621382flaps
flares94521702flares
flats86429742flats
flaws115920342flaws
flaxes165015352flaxes
flays116321052flays
flea75628492fl_ea
fleam106017282fleam
fleams115011942fleams
fleches153411442fleches
fleck148213592fleck
flecks154310802flecks
fled85429772fl_ed
fledges12409392fledges
fleece11369902fleece
fleeces12399642fleeces
fleech14367342fleech
fleecy14266482fleecy
flense938902flense
flenses1039472flenses
flesh115013742flesh
fleshes133913272fleshes
flew105824252fl_ew
flex146123472fl_ex
flexed17419092flexed
fley106626852fl_ey
fleyed13408812fleyed
flics105418362flics
flied96519432flied
flier86023402flier
fliers94417192fliers
fliest94718432fliest
flips105117742flips
flirs85518932flirs
flites95122442flites
flits85625222flits
flocs105519232flocs
floe76129772floe_
flogs95919962flogs
flops105920142flops
floss85118262floss
flows115822362flows
flubs105515442flubs
flue75329852flue_
flued95021252flued
flukes135114192flukes
flumes115119732flumes
flus75626542fl_us
flutes95421782flutes
fluxes165212932fluxes
flyer114916252flyer
flyers125712802flyers
flytes123911562flytes
foes76543442f_oes
foleys123810462foleys
folles93820472folles
fores85847102fores
foxes156321092foxes
free75940182free_
freed95223542freed
freer86021242freer
freers94717302freers
freest95318282freest
freres94716172freres
frets85523402frets
fries85535602fries
froes86126692froes
fuels87117352fuels
fumes105224702fumes
fusees95416402fusees
fuses85628422fuses
fuzees184910752fuzees
fuzes175120222fuzes
fyces139813642fyces
fykes156312692fykes
gees55647882_gees
gelees74116262gelees
ghees95215552ghees
glebes95512242glebes
gledes84915132gledes
gleds75417892gleds
glee55239062glee_
gleed75320572gleed
gleeds84711622gleeds
gleek105315102gleek
gleeks11489672gleeks
gleet65532342gleet
gleets75315052gleets
glens66519852glens
gleys96514852gleys
glues65125682glues
grees65132472grees
ileus54616892ileus
ilexes134510252ilexes
jees115938542_jees
knees95114872knees
leas45954182_leas
lee36068142_lee_
leek85331732_leek
leeks95318892_leeks
leer46239352_leer
leers54828982_leers
leet45957902_leet
leets54927122_leets
leges64427292_leges
legs56133692_legs
leis45739602_leis
leks85427602_leks
lenes54738522_lenes
lens46146492_lens
les35663072_l_es
leses54930812_leses
less45635102_less
lets47147942_lets
lexes127225262_lexes
leys76430182_leys
lies46454202_lies
lues45943552_lues
lyes75530832_lyes
melees83618082melees
ogees65119142ogees
oleos55419682oleos
oles46453472ol_es
pees65257372_pees
peles75738082peles
pleas75627032pleas
plebes104313622plebes
plebs95814582plebs
plews105415352plews
plexes155313542plexes
plies74526512plies
prees75937172prees
rees45364192_rees
sees45361052_sees
skees95023122skees
sleds64418852sleds
sleek94619042sleek
sleeks104512462sleeks
sleep74920182sleep
sleeps83913322sleeps
sleet55639132sleet
sleets64318872sleets
slews86220352slews
sloes54728872sloes
slues54527172slues
tees45353582_tees
teles54536002teles
trees55835762trees
tyees86019452tyees
vees75439432_vees
wees76249122_wees
ylems1039262ylems
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.310576422.6
2DLD Change Limit538002541.58034050.6
3Display Results2542540.0763342.1
 (SQL Overall)1786912541.96690890.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.