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

427 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
fishier1335985(None) 
dishier113613401dishier
fisher124917141fish_er
ashier94714832_ashier
bushier123712812bushier
cashier123713322cashier
cushier123610832cushier
dashier114311182dashier
feistier1136192feistier
fierier103511192fierier
fighter143010772fighter
filmier1237502filmier
filthier1434072filthier
finnier10319952finnier
firrier103410132firrier
fished134316312fish_ed
fishers134714722fish_ers
fishery16397732fish_ery
fishes125221342fish_es
fishiest14310452fishiest
fishily1637642fishily
fishing143913862fishing
fishnet13410342fishnet
fizzier18326712fizzier
flashier1437102flashier
fleshier1435602fleshier
friskier1535192friskier
fussier103610672fussier
fustier104213932fustier
gushier113110072gushier
hissier103410502hissier
meshier123410852meshier
mistier93418712mistier
mushier123813592mushier
pisher114317752pish_er
pithier123010292pithier
pushier123611092pushier
riskier1138422riskier
rushier103411972rushier
shier85428942__shier
sissier73711362sissier
swishier1434562swishier
washier133611152washier
wisher123617062wish_er
wispier12249402wispier
withier132910492withier
achier113914263_achier
airier64619363ai_rier
ashler9459973_ashler
basher115123813bash_er
beshiver1634483beshiver
bilgier10358533bilgier
bister84922763bis_ter
bitchier15307733bitchier
bitsier9379073bitsier
bittier94211663bittier
boskier13309173boskier
bossier93712423bossier
brashier13389933brashier
brushier13306973brushier
busher114922203bush_er
busier85219723bus_ier
bustier93916153bustier
cahier113615773_cahier
cashiers13318883cashiers
chichier1836023chichier
cipher133710263ciph_er
cissies94116153cissies
cither114616683cith_er
cosher114819903cosh_er
cosier84423763cos_ier
crispier12297263crispier
dasher104318983dash_er
dicier94416233di_cier
dickier143512453dickier
dictier103411863dictier
dingier93513673dingier
dinkier123411503dinkier
dippier123111393dippier
dirtier83312093dirtier
dished114318713dish_ed
dishes104622653dish_es
dishiest12313683dishiest
dishing124017103dishing
disliker13358643disliker
dither104417683dith_er
ditsier83010293ditsier
ditzier17307963ditzier
dizzier16317543dizzier
dossier83711693dossier
duskier12409433duskier
dustier83814133dustier
easier64218463eas_ier
either94517423eith_er
faddier1237783faddier
faggier12309843faggier
fancier123412063fancier
farrier103514893farrier
fashed136720253fash_ed
fashes124524023fash_es
fashing144918793fashing
fashion1337843fashion
fashioner15114323fashioner
faster94625773fas_ter
father125116713fath_er
fattier103513463fattier
fawnier13296363fawnier
fennier10339253fennier
fernier103110823fernier
fester94723513fes_ter
fibber134811933fi_bber
fiber104921133fi__ber
fibster12146533fibster
fiche134616743fich_e_
fiches145219533fich_es
fickler16348423fickler
fiddler12309953fiddler
fielder11217413fielder
fiercer12356953fiercer
fifer115519973fi__fer
fifties132111083fifties
fighters15269403fighters
figurer11215863figurer
filcher15377793filcher
filer85433003fi__ler
filler94623623fi_ller
fillies103420253fillies
filmer114112403fi_lmer
filter94517633fi_lter
finder104020233fi_nder
finer85431563fi__ner
finger104920333fi_nger
finisher1436303finish_er
firer811229253fi__rer
firmer114712443fi_rmer
fish106926283fish___
fisheries1548643fisheries
fisheye1644773fisheye
fisheyes1744093fisheyes
fishgig1542103fishgig
fishgigs1642093fishgigs
fishiness1537343fishiness
fishings15307693fishings
fishkill1842143fishkill
fishless1436413fishless
fishlike18225873fishlike
fishline14237583fishline
fishlines15246843fishlines
fishmeal1642663fishmeal
fishnets1445633fishnets
fishway1943813fishway
fishwife2042293fishwife
fishwives2142173fishwives
fishworm1943803fishworm
fishy146011663fish__y
fissile10269653fissile
fission1038733fission
fissiped1444153fissiped
fissure1036783fissure
fisted104218703fis_ted
fistic11812573fisti_c
fisting113818123fisting
fitter94120033fi_tter
fiver116024943fi__ver
fixer154717833fi__xer
fizzer17369383fi_zzer
flakier143910203flakier
flamier123112143flamier
flasher133914063flash_er
flawier13378733flawier
flaxier17337983flaxier
flesher133610923flesh_er
fleshlier1542493fleshlier
flichter1664963flichter
flier86023403f__lier
flightier1644423flightier
flimsier1344133flimsier
flintier1136393flintier
flirtier1144893flirtier
flossier11326973flossier
flukier14397853flukier
flusher133012273flush_er
flutier103011553flutier
flytier13356503flytier
foamier12339003foamier
foggier12349913foggier
folkier14359043folkier
footier104115113footier
forkier144311593forkier
foster94322223fos_ter
foxier163910033f_oxier
fozier183710663f_ozier
fresher132612643fresh_er
frier85225843f__rier
frillier1136513frillier
fringier1236553fringier
frisker14389273fris_ker
frizzier19284813frizzier
frostier1148163frostier
frothier1435953frothier
fubsier12367763fubsier
fuehrer1332973fuehrer
fuggier12348963fuggier
fuhrer1235033f_uhrer
fumier11310903f_umier
funkier14349983funkier
funnier103210173funnier
furrier103513663furrier
furzier19318103furzier
fusilier1135433fusilier
fusser94813773fus_ser
fuzzier18256523fuzzier
gasher104320373gash_er
gassier83812573gassier
giddier10308723giddier
gimpier12247943gimpier
ginnier8298983ginnier
girlier8289523girlier
grislier935793grislier
gusher104115773gush_er
gustier83813863gustier
hastier103916623hastier
higher134610893high_er
hillier103413963hillier
hinkier143610793hinkier
hippier143212103hippier
hisser94713793his_ser
hissies103915823hissies
hither124417253hith_er
hosier94219613hos_ier
huskier14369763huskier
icier74313753_i_cier
ickier12439923_ickier
iffier1236763_iffier
inkier104013783_inkier
inlier63615363_inlier
isomer8310153_isomer
issuer646623_issuer
itchier12247673itchier
ither84617603_ith_er
jiggier16377823jiggier
jivier16438613ji_vier
josher164312963josh_er
kasher134915033kash_er
kickier12349053kickier
kinkier10319433kinkier
kishke1254273kishke_
kishkes1334773kishkes
kisser104212453kis_ser
kosher134412973kosh_er
lasher94824533lash_er
lathier10310833lathier
lighter113113443lighter
limbier11349113limbier
limier83518723li_mier
lingier84113383lingier
linier64423793li_nier
lintier73613803lintier
lippier112710573lippier
lisper84114433lis_per
lister64527253lis_ter
lither94520953lith_er
livier97514593li_vier
lusher93818763lush_er
lustier73813503lustier
luthier1038233luthier
marshier1337593marshier
masher114123203mash_er
mashie11315933mashie_
mashies12318253mashies
massier93615223massier
messier93412923messier
miffier1537023miffier
mightier1436383mightier
milkier133411163milkier
millier93716703millier
miltier93214963miltier
mincier113512473mincier
mingier103815293mingier
mintier93615993mintier
mirier83918363mi_rier
mirkier13319053mirkier
misaver1249813misaver
mischief1846423mischief
misdoer1048633misdoer
miser75430403mis__er
misfire12229893misfire
mishear1238393mishear
mishit112618203mishi_t
mishits122513083mishits
mislie83219153mislie_
mislies92922283mislies
misliker14319573misliker
missies93423983missies
mister84728563mis_ter
misuser93210443misuser
mither114218563mith_er
mitier83620673mi_tier
mosher114719793mosh_er
mossier94413813mossier
mothier121910213mothier
musher113820573mush_er
muskier134312733muskier
mussier93314363mussier
mustier94017963mustier
mythier15125183mythier
nastier74115293nastier
niftier10328713niftier
nigher103612753nigh_er
nippier11319833nippier
nittier73512243nittier
noisier759463nois_ier
nosher94616363nosh_er
nosier63716333nos_ier
oilier64417233oi_lier
osier53518013_os_ier
pastier94320383pastier
peskier13319113peskier
pestier94317403pestier
pickier153912973pickier
piggier113510003piggier
pinier84024693pi_nier
pipier104913983pi_pier
pished124817063pish_ed
pishers123815753pish_ers
pishes114722103pish_es
pishing134314373pishing
pismire1135353pismire
pisser84416383pis_ser
pitchier15368273pitchier
pitier84019823pi_tier
plashier1337613plashier
plushier1375193plushier
posher115018163posh_er
prissier10157873prissier
pusher114318283push_er
pussier93711993pussier
rasher95024123rash_er
raspier93110643raspier
ribbier1137593ribbier
ribier84414233ri_bier
richer114015043rich_er
ridgier937883ridgier
righter113212383righter
rimier83916273ri_mier
riser55431053ris__er
rishi8311253rishi__
rishis9312453rishi_s
risker105414493ris_ker
ritzier16297203ritzier
rosier64221273ros_ier
rusher94019653rush_er
rustier74416363rustier
sassier73413233sassier
sheer84726893__sheer
shied96125493__shied
shiel811023773__shiel
shiers94921753__shiers
shies86136553__shies
shiner93820873__shiner
shire84727133__shire
shirr84716923__shirr
shiver124517373__shiver
shoer84722163__shoer
shyer114714783__shyer
sigher103813703sigh_er
sighter113412113sighter
silkier114411643silkier
sillier74017593sillier
siltier73413863siltier
sissies73716603sissies
sister64421583sis_ter
sizier1514813393si_zier
skier95119603__skier
slier54827243__slier
sloshier1135283sloshier
slushier1135983slushier
spier75728033__spier
squishier2143383squishier
swisher13369523swish_er
tastier711817093tastier
techier1269243techier
testier74015643testier
tidier73515113ti_dier
tighter112910693tighter
tinier63622233ti_nier
tinnier72910143tinnier
tippier113210543tippier
tipsier9268893tipsier
tither94920283tith_er
trashier113210103trashier
tushie939723tushie_
tushies10312163tushies
twistier1134813twistier
usher84517763_ush_er
vastier103613203vastier
vichies15310623vichies
viewier1334983viewier
vinier93716743vi_nier
visiter1038863visiter
vizier184311023vi_zier
washer124720393wash_er
waspier12259053waspier
wiftier13297733wiftier
wiggier12418863wiggier
wilier93217073wi_lier
wimpier14248053wimpier
windier113412163windier
wingier113413283wingier
winier94522453wi_nier
wirier94215553wi_rier
wiselier1137363wiselier
wiser85522803wis__er
wished134417513wish_ed
wishers133215213wish_ers
wishes124920953wish_es
wishing144114893wishing
witchier16307883witchier
wither124321353with_er
withies133913543withies
wittier103910823wittier
wristier1136863wristier
wussier10408083wussier
zestier163010223zestier
zingier17369493zingier
zippier20308193zippier
zither183813083zith_er

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.423422437.4
2DLD Change Limit1340274277.15618729.3
3Display Results4274270.1532790.8
 (SQL Overall)1786914277.73223110.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.