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

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
fleas8642366(None) 
flea75628491flea_
fleam106017281fleam
fleams115011941fleams
flees85828751flees
flews115316441flews
fleys117015601fleys
leas45954181_leas
pleas75627031pleas
alas46358122al_as
albas75925392albas
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
alfas87219042alfas
algas65624932algas
alias55834602alias
almas76629772almas
areas55935772areas
befleas1236972befleas
bleak115915382bleak
bleaks125112432bleaks
blear75918682blear
blears85116452blears
bleat75737002bleat
bleats85518612bleats
blebs96416152blebs
bless75917812bless
blets75324942blets
clean75420412clean
cleans85817052cleans
clear76219052clear
clears84116562clears
cleat76335062cleat
cleats84919312cleats
clefs106616242clefs
clews105516332clews
defleas1147222defleas
faenas94412762faenas
fas68262932f__as
favas115618592favas
feal713940422f_eal
fear75337792f_ear
fears84829392f_ears
fease84824872f_ease
feast85932722f_east
feat76458222f_eat
feats86432752f_eats
feds85234312f_eds
feebs106112682feebs
feeds94921142feeds
feels85223042feels
fees76450602f_ees
fehs106522382f_ehs
fellas95116962fellas
fells85327382fells
felts85324542felts
fems96428702f_ems
fens76139762f_ens
fes66551672f_e_s
fess76529162f_ess
fetas85624402fetas
fets75345942f_ets
feus75830752f_eus
fiefs116213702fiefs
filers94623722filers
files85441272file_s
filets94718952filets
flab96628352fl_ab
flabs105818642flabs
flag87427082fl_ag
flags95321282flags
flak116026172fl_ak
flam96333292fl_am
flams105125012flams
flan76134182fl_an
flans85327972flans
flap96128702fl_ap
flaps105621382flaps
flash115716212fl_ash
flask125512422fl_ask
flat77147822fl_at
flats86429742flats
flaw106326642fl_aw
flaws115920342flaws
flax147325632fl_ax
flay106332802fl_ay
flays116321052flays
fleck148213592fleck
flecks154310802flecks
fled85429772fle_d
flee76238792fle_e
fleer86020772fleer
fleers96015792fleers
fleet85932332fleet
fleets96915062fleets
flense938902flense
flesh115013742flesh
flew105824252fle_w
flex146123472fle_x
flexes164512952flexes
fley106626852fle_y
flics105418362flics
fliers94417192fliers
flies85630712flies
flips105117742flips
flirs85518932flirs
flits85625222flits
float85928572float
floats96816252floats
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flops105920142flops
floras94715692floras
floss85118262floss
flotas94013002flotas
flows115822362flows
flubs105515442flubs
flues84626922flues
flus75626542fl_us
flyers125712802flyers
foes76543442foe_s
foleys123810462foleys
foveas1238622foveas
freak125115242freak
freaks134713062freaks
frees86131392frees
frets85523402frets
fuels87117352fuels
galeas74618512galeas
gleam86916732gleam
gleams94812252gleams
glean65818202glean
gleans75014742gleans
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
glias64618492glias
ideas65919012ideas
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
ileus54616892ileus
keas86337092_keas
las37281472_l_as
lea37660182_lea_
lead56038852_lead
leads66028492_leads
leaf76441032_leaf
leafs85721182_leafs
leak86233712_leak
leaks95923912_leaks
leal46043272_leal
lean46345242_lean
leans55536252_leans
leap66032682_leap
leaps75522932_leaps
lear47045952_lear
lears55938732_lears
lease55230262_lease
leash85519212_leash
least56134882_least
lees45455882_lees
legs56133692_legs
leis45739602_leis
leks85427602_leks
lens46146492_lens
les35663072_le_s
less45635102_less
lets47147942_lets
leys76430182_leys
olea46532722olea_
oleos55419682oleos
oles46453472ole_s
ollas54218282ollas
peas65755062_peas
plea66830602plea_
plead85818462plead
pleads94613952pleads
please84315732please
pleat74734472pleat
pleats85218592pleats
plebs95814582plebs
plews105415352plews
rheas84816952rheas
seas45755272_seas
sheas86331792sheas
sleds64418852sleds
slews86220352slews
teas45851492_teas
toeas55726422toeas
ulemas888962ulemas
ulnas55716532ulnas
ulvas84511502ulvas
ureas55826012ureas
uveas84912282uveas
yeas78638422_yeas
ylems1039262ylems
zoeas145815612zoeas

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.296603685.8
2DLD Change Limit538002011.40638264.6
3Display Results2012010.0464369.6
 (SQL Overall)1786912011.748102226.0
 
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.