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

402 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
flesher13361092(None) 
flasher133914061flasher
fleshed143210261fleshed
fleshers14339441fleshers
fleshes133913271fleshes
fleshier1435601fleshier
flusher133012271flusher
fresher132612641fresher
blesser9329292blesser
blether12459912blether
blusher124113112blusher
clasher124615512clasher
feldsher1543242feldsher
fester94723512f_ester
fisher124917142f_isher
flashed144112182flashed
flashers143912652flashers
flashes133916102flashes
flashier1437102flashier
fleche14299302fleche_
fleches153411442fleches
fleecer12368032fleecer
fleer86020772fle__er
fleeter103210362fleeter
flenser1036782flenser
flesh115013742flesh__
fleshlier1542492fleshlier
fleshly16346092fleshly
fleshy15406282flesh_y
fletcher16306662fletcher
flosser10339692flosser
flushed143310972flushed
flushers14279732flushers
flushes134114142flushes
fluster103913062fluster
freshed143312592freshed
freshen133010882freshen
freshes133515822freshes
freshet133416642freshet
lasher94824532_lasher
lecher113415852_lecher
lesser63514852_lesser
lusher93818762_lusher
plasher124215032plasher
plusher124010382plusher
slasher104515322slasher
welsher13377442welsher
aether94213673_aether
alerter72111513alerter
basher115123813_basher
belcher143511493belcher
blaster94017303blaster
blather125314203blather
bleacher15358883bleacher
bleaker133510533bleaker
bleater94515303bleater
bleeder10359643bleeder
bleeper11458253bleeper
blemisher1663653blemisher
blencher15308393blencher
blender104613843blender
blessed10319493blessed
blessers10277623blessers
blesses93812393blesses
blethers13429613blethers
blister94415313blister
blither124812173blither
blucher143310223blucher
bluesier1034943bluesier
blushed134411753blushed
blushers133911293blushers
blushes124314823blushes
bluster94215313bluster
brasher124515233brasher
brusher123813003brusher
busher114922203_busher
clashed133614013clashed
clashers134213993clashers
clashes124017283clashes
clasper113811863clasper
classer93614613classer
cleaner93712303cleaner
clearer93710823clearer
cleaver124110803cleaver
clencher15277973clencher
clever114611533cle_ver
closer84918203clos_er
cluster94013323cluster
clyster12317453clyster
cosher114819903_cosher
crasher124616153crasher
crusher124412323crusher
dasher104318983_dasher
diester83013683diester
diether1147443diether
dresser83611953dresser
esker94412983__esker
ester54727713__ester
ether84518773__ether
falser93912413fals_er
farther1348343farther
fashed136720253f_ashed
fashes124524023f_ashes
faster94625773f_aster
father125116713f_ather
fearer94820183f_earer
feaster10812983feaster
feater95224053f_eater
feather133613503feather
feebler1235823feebler
feeder103513843f_eeder
feeler93215173f_eeler
feldscher1842023feldscher
feldshers1643093feldshers
feller94419553f_eller
felspar1243283felspar
fencer114613533f_encer
fender103718723f_ender
fesse86116333f_esse_
fessed104515063f_essed
fesses94820253f_esses
festers104121393f_esters
fetcher153510393fetcher
fetter94120383f_etter
fever115617953f_e_ver
fewer115216123f_e_wer
feyer115014523f_e_yer
fibster12146533fibster
fielder11217413fielder
fiercer12356953fiercer
fierier103511193fierier
filcher15377793filcher
filister1137403filister
finisher1436303finisher
fished134316313f_ished
fishers134714723f_ishers
fishery16397733f_ishery
fishes125221343f_ishes
fishier13359853f_ishier
flagger12469353flagger
flaker134916173fl_aker
flakier143910203flakier
flamer114919123fl_amer
flamier123112143flamier
flanger113412623flanger
flanker143911293flanker
flapper14359203flapper
flash115716213flash__
flashover1843133flashover
flashy15498173flash_y
flasket1439733flasket
flatter103815963flatter
flawier13378733flawier
flaxier17337983flaxier
flayer124713563fl_ayer
flecked17358073flecked
fledge11439293fledge_
fledged13417843fledged
fledges12409373fledges
fledgier1333683fledgier
flee76238793fle__e_
fleece11369903fleece_
fleeced13358153fleeced
fleecers13325933fleecers
fleeces12399643fleeces
fleeched17345823fleeched
fleeches16287083fleeches
fleecier1334763fleecier
fleered11309503fleered
fleers96015793fle__ers
flees85828753fle__es
fleet85932333fle__et
fleeted113310233fleeted
flehmen1534913flehmen
fleishig1542893fleishig
flemished1853633flemished
flemishes1765243flemishes
flenched17267963flenched
flenches163410533flenches
flense938903flense_
flensed1136613flensed
flensers1135463flensers
flenses1039473flenses
fleshiest1576223fleshiest
fleshily1744533fleshily
fleshing15339303fleshing
fleshless1543993fleshless
fleshment1745503fleshment
fleshpot1643843fleshpot
fletched17306693fletched
fletchers17335533fletchers
fletches16308853fletches
flexed17419083fle_xed
flexes164512953fle_xes
flexor1634503fle_xor
flexure1743413flexure
fleyed13408813fle_yed
flichter1664963flichter
flicker163610623flicker
flier86023403fl__ier
flimsier1344133flimsier
flincher16256583flincher
flinder11319873flinder
flinger113710513flinger
flipper14389143flipper
flirter10318673flirter
flitter103413903flitter
flivver1633043flivver
floater104413353floater
flogger12449463flogger
flooder11258463flooder
floorer10248073floorer
flopper14328473flopper
flossed11388533flossed
flossers11307863flossers
flosses103411973flosses
flossier11326973flossier
flouter104311343flouter
flower124815503fl_ower
flubber14287713flubber
fluffer12336503fluffer
flukier14397853flukier
flunker14389363flunker
flush115116073flush__
flushest14338553flushest
flusters113811493flusters
fluter95316863fl_uter
flutier103011553flutier
flutter104012093flutter
flyer114916253fl__yer
flyover1633513flyover
flysches1933123flysches
flysheet1745113flysheet
flytier13356503flytier
folksier1533533folksier
foolisher1544223foolisher
foreseer1139013foreseer
forester11313673forester
foster94322223f_oster
freer86021243fre__er
freezer19348523freezer
frescoer1345983frescoer
fresh115012203fresh__
freshener1544853freshener
freshens14298313freshens
freshest143010583freshest
freshets14298673freshets
freshly16286833freshly
freshmen1656023freshmen
fresnel1035893fresnel
fretter103412753fretter
frisker14389273frisker
frother133110153frother
fubsier12367763fubsier
fuehrer1332973fuehrer
fueler94313933fue_ler
fueller10279963fueller
further1337003further
fusser94813773f_usser
fussier103610673fussier
gasher104320373_gasher
gleamer10328513gleamer
gleaner8379773gleaner
glister84013343glister
glosser83410813glosser
guesser8166543guesser
gusher104115773_gusher
harsher13310363harsher
jester134319153_jester
josher164312963_josher
kasher134915033_kasher
keester11319913keester
kiester11329973kiester
klezmer2231933klezmer
klister113410643klister
kosher134412973_kosher
laser54633323_las_er
lashed105625213_lashed
lashers104121833_lashers
lashes94831003_lashes
laster64830633_laster
lather95124353_lather
leacher124014843_leacher
leader74824653_leader
leaker104620073_leaker
leaner64022193_leaner
leaper88118943_leaper
leaser65322673_leaser
leashed113211163_leashed
leashes103514403_leashes
leather103815783_leather
leaver94321513_leaver
leched123716003_leched
lechers123313963_lechers
lechery15257643_lechery
leches115421313_leches
ledger85914363_ledger
leer46239353_le__er
lefter93613433_lefter
leger65721503_le_ger
lehr75514943_le_h_r
leister73212753_leister
lender73921273_lender
leper74820743_le_per
leses54930813_les_es
lessee64116363_lessee
lessen64212433_lessen
lessor64010603_lessor
lethe85717303_lethe_
lethes94818083_lethes
letter63722583_letter
lever85125163_le_ver
levier94013873_levier
lewder10479613_lewder
lisper84114433_lisper
lister64527253_lister
lither94520953_lither
loser54728673_los_er
lushed104218723_lushed
lushes94022743_lushes
luster64023673_luster
masher114123203_masher
meshed124415933_meshed
meshes115019443_meshes
meshier123410853_meshier
molester1099373molester
mosher114719793_mosher
musher113820573_musher
nester64124183_nester
nether94014163_nether
nosher94616363_nosher
oldster896573oldster
oleaster837263oleaster
pester84827593_pester
pisher114317753_pisher
plashed133712643plashed
plashers133813453plashers
plashes124417393plashes
plashier1337613plashier
plaster93318693plaster
pleader103511753pleader
pleaser93912343pleaser
pleater93916333pleater
pleather1356653pleather
pledger11359153pledger
plessor9317693plessor
plushes124313673plushes
plushier1375193plushier
polisher1388073polisher
posher115018163_posher
presser93717623presser
prester93519623prester
pusher114318283_pusher
quasher19198623quasher
quester161410023quester
rasher95024113_rasher
refresher15104653refresher
reshes94124363_reshes
rester63832433_rester
rusher94019653_rusher
shusher13288113shusher
slashed114114853slashed
slashers113313603slashers
slashes103619103slashes
slather103816063slather
sledder9399203sledder
sleeker11339823sleeker
sleeper93211563sleeper
sleigher1234313sleigher
slender83413593slender
slither104112983slither
sloshed11329823sloshed
sloshes103811803sloshes
sloshier1135283sloshier
slushed113611243slushed
slushes103514413slushes
slushier1135983slushier
smasher123911013smasher
splasher1335653splasher
swasher134011503swasher
swisher13369523swisher
teether10349693teether
telpher1235563telpher
tester64227153_tester
tether93716103_tether
thresher1455823thresher
trasher104416123trasher
ulster63712103ul_ster
usher84517763__usher
vesper1138083_vesper
washer124720393_washer
welcher15319393welcher
welshed14277203welshed
welshers14246813welshers
welshes13379093welshes
wester94222893_wester
wether123315393_wether
whether16346623whether
wisher123617063_wisher
wrester102812413wrester
yester93417983_yester
zester153617793_zester

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.1701051123.5
2DLD Change Limit1340274027.12618808.2
3Display Results4024020.1562576.9
 (SQL Overall)1786914027.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.