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

305 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
coiffe144704(None) 
coiffed1635411coiffed
coiffes1546801coiffes
bouffe14438312bouffe
cliff135917132cliff_
cliffs14477592cliffs
cliffy17435242cliffy
coff126930782co_ff_
coffee144113742coffee
coffer144112862co_ffer
coffle14359042coffle
coffs134916302co_ffs
coif96337912coi_f_
coifed124113062coifed
coiffeur1642152coiffeur
coiffure1643122coiffure
coifs105718702coi_fs
coigne94612192coigne
coinfer12419392coinfer
griffe13438092griffe
pouffe14448262pouffe
biff125026893_biff_
biffed15449883_biffed
biffs134814413_biffs
biffy164711133_biffy
boff124727333bo_ff_
boffed15369483bo_ffed
boffo136010373bo_ffo
boffs134915503bo_ffs
boite74426323boi_te
bouffes15388633bouffes
cafe95230323c__afe
caff125631673c_aff_
caffs135417373c_affs
caique17318803caique
carafe115416163carafe
chafe135117353c_hafe
chaff165016283chaff_
chaffed19387703chaffed
chaffer18389473chaffer
chaffs17459613chaffs
chaffy20456473chaffy
cheffed19335863cheffed
chicle134312543chicle
chide115321013chi_de
chief134419483chief_
chiefer1536863chiefer
chiefs14509653chiefs
chiffon1844053chiffon
chigoe1237533chigoe
childe124711213childe
chile105626893chi_le
chime125322593chi_me
chine105231723chi_ne
chirre114111853chirre
chive135117623chi_ve
choice132010523choi_ce
chuff164812493chuff_
chuffed19316643chuffed
chuffer18337143chuffer
chuffs17427783chuffs
chuffy20445863chuffy
cine66242943c_i_ne
cire65836373c_i_re
cite65640343c_i_te
civie103716353c_ivie
cliche133712453cliche
cliffier1633913cliffier
clift106422193cli_ft
clifts11519153clifts
clime95720893cli_me
cline76428533cli_ne
clique17289193clique
cnidae978143cnidae
coarse84813903coarse
coatee84327223coatee
cobble123615263cobble
coble94823173co_ble
cockle143913573cockle
coddle104713853coddle
code77347733co__de
codified1537403codified
codifier1447163codifier
codifies1439643codifies
codify1537163codify
coeffect1843933coeffect
coerce10310403coerce
coffees15329573coffees
coffers154112693co_ffers
coffin14339813coffin
coffled16297363coffled
coffles152610003coffles
coffret15310073coffret
coft97939683co__ft
cohere112716993cohere
cohune1189423cohune
coiffeurs1741963coiffeurs
coiffeuse1741613coiffeuse
coiffing1755933coiffing
coiffured1842613coiffured
coiffures1743213coiffures
coifing133213893coifing
coign85013913coi_gn
coigned11418663coigned
coignes103912153coignes
coigns94410063coigns
coil66439653coi__l
coiled95123933coiled
coiler84421593coiler
coils75030083coi_ls
coin66645353coi__n
coinage10310553coinage
coined94523603coined
coiner84323783coiner
coinfect15276843coinfect
coinfers13349503coinfers
coins75834553coi_ns
cointer93616723cointer
coir66327243coi__r
coirs75221053coi_rs
coital84117053coital
coitus8511893coitus
coke107038383co__ke
cole66956113co__le
collie83621993collie
colone85425003colone
colure8314163colure
comade114415323comade
comae97128423co_mae
comake144413423comake
comate104124843comate
combe116223543co_mbe
come87547703co__me
comfier1439163comfier
comfit133112423comfit
comfrey1734683comfrey
comfy153710213co_mfy
commie124215523commie
comose105016843comose
comte96125473co_mte
cone67256963co__ne
confab1347063confab
confer114018683confer
confide13310203confide
confine12315583confine
confit113316403confit
confuse1238853confuse
confute1239263confute
conge85227593co_nge
congee96024463congee
conifer123212643conifer
coniine9316803coniine
conine84528553conine
conte76633203co_nte
cooee74531023co_oee
coof96643273co_of_
coofs105924713co_ofs
cookie123716043cookie
coolie83821603coolie
coombe124110093coombe
cootie84223093cootie
cope86847383co__pe
copihue1444143copihue
copse95623923co_pse
corbie103618203corbie
core67263113co__re
corf95941483co_rf_
cornfed1337383cornfed
corpse104013403corpse
corrie83621223corrie
corse75036183co_rse
corvee114320093corvee
cosie74728263co_sie
cosine83823513cosine
costae85319683costae
cote66648733co__te
cottae84615703cottae
cotype1346823cotype
coude85022633co_ude
coulee8323503coulee
coupe96023483co_upe
couple104415963couple
course85117783course
cove95837073co__ve
cowage12310663cowage
cowpie133511513cowpie
cowrie113814283cowrie
coxae146115183co_xae
coyote11411783coyote
cozie163519133co_zie
crime94822693cri_me
cringe93515483cringe
cripe95521143cri_pe
cuff125327993c_uff_
cuffed154311213c_uffed
cuffs135017493c_uffs
cuif96529143cui_f_
cuifs104814693cui_fs
cuisse8318333cuisse
diff116228843_diff_
differ133910843_differ
diffs126315483_diffs
doff116225783do_ff_
doffed14428503do_ffed
doffer133911353do_ffer
doffs125614333do_ffs
fife106027703_fi_fe
foible11410383foible
gaffe124111653_gaffe
gliff124915663gliff_
gliffs13436323gliffs
goffer13409513go_ffer
goitre7349003goitre
goniff13408893goniff_
goniffs14473903goniffs
griff124416463griff_
griffes14367923griffes
griffs13398993griffs
hoise85224773hoi_se
howff175110493howff_
howffs18535043howffs
iff96730393__iff_
iffy135312283__iffy
jiff175321413_jiff_
jiffs185710313_jiffs
jiffy21458313_jiffy
knife1210010133kni_fe
koine9516483koi_ne
life75433733_li_fe
miff125625063_miff_
miffed15398713_miffed
miffs134512883_miffs
miffy163910203_miffy
moire71017323moi_re
niffer12378443_niffer
noise55723733noi_se
off96331633_o_ff_
offed12359163_o_ffed
offer114311383_o_ffer
offs107117013_o_ffs
piaffe1494913piaffe
piffle14418233_piffle
pointe84619313pointe
poise75127893poi_se
pouff135215423pouff_
pouffed16365953pouffed
pouffes15408123pouffes
pouffs14418123pouffs
pouffy17395883pouffy
quiff201111563quiff_
quiffs21135433quiffs
rife74632323_ri_fe
riff104430103_riff_
riffed133811563_riffed
riffle124210233_riffle
riffs115114613_riffs
rifle85518333_rifle
roofie93411173roofie
ruffe114713813_ruffe
scoff134413343sco_ff_
scoffed16266183sco_ffed
scoffer15317023sco_ffer
scoffs14347503sco_ffs
skiff153612803skiff_
skiffle17225203skiffle
skiffs16327013skiffs
sniff113915863sniff_
sniffed14318183sniffed
sniffer13318903sniffer
sniffle13287653sniffle
sniffs12378843sniffs
sniffy15337193sniffy
soigne74310033soigne
soiree62919483soiree
souffle13306803souffle
spiff133616403spiff_
spiffed16257103spiffed
spiffs14328473spiffs
spiffy17326223spiffy
stiff114219243stiff_
stiffed14359583stiffed
stiffen13286023stiffen
stiffer13319393stiffer
stiffie13245773stiffie
stiffs12389963stiffs
stifle93611903stifle
tiff104727723_tiff_
tiffed13368393_tiffed
tiffs114414883_tiffs
toff105929903to_ff_
toffee123311013toffee
toffs116016723to_ffs
toffy145310283to_ffy
toile54626493toi_le
trifle94012883trifle
truffe1276233truffe
voice104915323voi_ce
voile84719723voi_le
whiff17310063whiff_
whiffed2064473whiffed
whiffer19105323whiffer
whiffet1965343whiffet
whiffle1933533whiffle
whiffs1835083whiffs
wife105228023_wi_fe

Search took 9 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.1401276364.3
2DLD Change Limit1127163057.97014142.5
3Display Results3053050.0933279.6
 (SQL Overall)1786913058.20321783.6
 
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.