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

292 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
feoffs116370(None) 
feoff10711051feoff_
boffs134915502_boffs
coffs134916302_coffs
dieoffs1443032dieoffs
doffs125614332_doffs
effs105114032_e_ffs
enfeoffs1361822enfeoffs
feods99516852feo_ds
feoffed1332812feoffed
feoffee1243902feoffee
feoffees1342162feoffees
feoffer1233022feoffer
feoffers1333132feoffers
feoffor1241782feoffor
feoffors1341982feoffors
fluffs11347782fluffs
flyoffs1542252flyoffs
infeoffs1352082infeoffs
offs107117012__offs
scoffs14347502scoffs
setoffs1334132setoffs
teffs115111732te_ffs
toffs116016722_toffs
aeons57624653aeo_ns
baffs134718053_baffs
beefs105618563be_efs
befogs1246453befogs
biffs134814403_biffs
blaffs14426623blaffs
bluffs14388373bluffs
boff124727323_boff_
boffo136010373_boffo
boffos14568193_boffos
buffs135519513_buffs
buyoffs1842433buyoffs
caffs135417373_caffs
ceorls848163ceorls
chaffs17459613chaffs
chuffs17427783chuffs
cliffs14477593cliffs
coff126930783_coff_
coifs105718703_coifs
coofs105924713_coofs
crofts114910593crofts
cuffs135017493_cuffs
cutoffs1533603cutoffs
daffs125116423_daffs
decafs124010883decafs
defis96717503de_fis
defogs1156683defogs
delfs94918673de_lfs
delfts10439673delfts
dieoff1335503dieoff_
diffs126315483_diffs
doff116225783_doff_
doofus1036163doofus
draffs13617903draffs
duffs125216623_duffs
eff96128623_e_ff_
efs66829603_e__fs
efts76519483_e_fts
enfeoff1272793enfeoff_
eons46638713_eo_ns
falloffs1343253falloffs
fears84829393fe_ars
feases95422923feases
feasts95116093feasts
feats86432753fe_ats
feazes184514173feazes
feces105625363fe_ces
fecks145417853fe_cks
fedoras1137923fedoras
feds85234313fe__ds
feebs106112683fe_ebs
feeds94921143fe_eds
feels85223043fe_els
fees76450603fe__es
feezes184412613feezes
fehs106522383fe__hs
feigns10407753feigns
feints94813873feints
feists94915313feists
felids103111623felids
fellas95116963fellas
fells85327383fe_lls
felons93615763felons
felts85324543fe_lts
femes105626223fe_mes
femmes135410213femmes
fems96428703fe__ms
femurs1136713femurs
fences114617113fences
fends96324973fe_nds
fens76139763fe__ns
feod815523003feo__d
feoffing1432963feoffing
ferals94216643ferals
feres86038183fe_res
ferias95020393ferias
fermis114313503fermis
ferns85220083fe_rns
fes66551673fe___s
fess76529163fe__ss
fesses94820253fesses
fests85828043fe_sts
fetas85624403fe_tas
fetes85630143fe_tes
fetors91014473fetors
fets75345943fe__ts
fetus85816543fe_tus
feuars938653feuars
feuds95914883fe_uds
feus75830753fe__us
fevers125414893fevers
fezes175220023fe_zes
fezzes174910403fezzes
fiefs116213703f_iefs
fifes114822393f_ifes
fiords10498623fiords
fjords17405353fjords
floats96816253floats
flocks154713533flocks
flocs105519233flo_cs
floes85528143flo_es
flogs95919963flo_gs
flongs105010493flongs
floods104511653floods
floors94112353floors
flops105920143flo_ps
floras94715693floras
floss85118263flo_ss
flotas94013003flotas
flours94414053flours
flouts94315273flouts
flows115822363flo_ws
fluff103913613fluff_
fluffy14315783fluffy
flyoff1444023flyoff_
foals85721693f_oals
foams105017953f_oams
fobs96034273f_o_bs
focus105815883f_ocus
foehns12204973foehns
foes76543443f_o_es
foetus958523foetus
fogs87035003f_o_gs
fohns117310783f_ohns
foils85025813f_oils
foins85523383f_oins
folds95221693f_olds
folks126017123f_olks
fonds95824823f_onds
fons76943893f_o_ns
fonts86124753f_onts
foods95924163f_oods
fools86824203f_ools
foots85528283f_oots
fops96532683f_o_ps
forbs105720803f_orbs
fords95328183f_ords
fores85847103f_ores
forks125324683f_orks
forms105327053f_orms
forts86034453f_orts
foss76431643f_o_ss
fouls87221433f_ouls
fours85521493f_ours
fowls115518893f_owls
foxes156321093f_oxes
foys105628293f_o_ys
frocks154111213frocks
froes86126693fro_es
frogs96220773fro_gs
fronds106412343fronds
frons86124043fro_ns
fronts94415793fronts
frosts94214623frosts
froths125411443froths
frowns126011393frowns
frows116623103fro_ws
fuckoffs1941713fuckoffs
gaffs124914653_gaffs
geodes8412153geodes
geoids8369843geoids
gliffs13436323gliffs
golfs95616103_golfs
goofs94821003_goofs
griffs13398993griffs
gruffs13337453gruffs
guffs124414823_guffs
hefts116218153he_fts
hoofs115721043_hoofs
howffs18535043howffs
howfs144814503_howfs
huffs144514743_huffs
infeoff1253263infeoff_
jefes155613673je_fes
jiffs185710313_jiffs
keefs125116283ke_efs
kefs115922743ke__fs
kenafs1337113kenafs
kerfs125413573ke_rfs
kloofs13386353kloofs
layoffs1642573layoffs
leadoffs1542303leadoffs
leafs85721183le_afs
lefts86517813le_fts
leones64417723leones
liftoffs1342063liftoffs
loafs85616993_loafs
lofts85518363_lofts
loofas9429833loofas
loofs85623783_loofs
luffs114516283_luffs
meous76120063meo_us
meows104612683meo_ws
miffs134512873_miffs
muffs134114213_muffs
naffs116213963_naffs
neifs85613043ne_ifs
neons55818683neo_ns
oafs76425263__oafs
off96331633__off_
payoffs1843243payoffs
pelfs105016293pe_lfs
peones83821043peones
peons75327183peo_ns
poofs105222793_poofs
pouffs14418123pouffs
poufs105616063_poufs
profs105120893pro_fs
proofs114511683proofs
puffs134114933_puffs
putoffs1543333putoffs
quaffs21125693quaffs
quiffs21135433quiffs
raffs115017523_raffs
rakeoffs1842203rakeoffs
rebuffs1533403rebuffs
reefs85121663re_efs
refs75732243re__fs
reifs84819093re_ifs
reoffer1335013reoffer
reoffers1434693reoffers
reoils64516873reoils
reroofs1037943reroofs
riffs115114613_riffs
ripoffs1543383ripoffs
rolfs84817123_rolfs
roofs85321153_roofs
ruboffs1543113ruboffs
ruffs114516743_ruffs
runoffs1343013runoffs
scoff134413343scoff_
scuffs14419053scuffs
seifs85019333se_ifs
selfs85220243se_lfs
selloffs1443623selloffs
sendoffs1543493sendoffs
serfs84922013se_rfs
serifs94017053serifs
setoff1238913setoff_
shroffs1634353shroffs
skiffs16327013skiffs
sluffs12349583sluffs
sniffs12378843sniffs
snuffs12358523snuffs
sofas85320713_sofas
softs85019233_softs
spiffs14328473spiffs
spoofs114011813spoofs
staffs12349753staffs
stiffs12389963stiffs
stuffs123810223stuffs
takeoffs1842323takeoffs
teff106023763te_ff_
tiffs114414883_tiffs
tipoffs1543033tipoffs
toff105929903_toff_
toffy145310283_toffy
tofts84919243_tofts
tofus86415423_tofus
tuffs115118263_tuffs
waffs146315473_waffs
waveoffs2042043waveoffs
wefts116715493we_fts
whiffs1835083whiffs
whoofs15457243whoofs
wolfs116214163_wolfs
woofs114918003_woofs
yaffs145311123_yaffs

Search took 7 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162926.22018121.5
3Display Results2922920.0933139.8
 (SQL Overall)1786912926.46927622.7
 
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.