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

309 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
ciscoes11361073(None) 
ciscos104711131cisco_s
cinches144215772cinches
circles1139902circles
cisco95112132cisco__
cissies94116152cissies
discoed11312482discoed
discos94915212disco_s
fiascoes13134922fiascoes
ficoes114613462fi_coes
miscodes13310422miscodes
miscues11312392miscues
misdoes10312492misdoes
piscos105112592pisco_s
roscoes9310922roscoes
viscose1237862viscose
viscoses1338342viscoses
viscous1238832viscous
aisles64721143ais_les
aitches123014363aitches
ascots85312513_ascots
bices95029963bi_c_es
bilboes114410243bilboes
bimboes13498733bimboes
bingoes104013983bingoes
bioscopes1546553bioscopes
birches143412323birches
bises75435623bis__es
bishops1437033bishops
bisons83914373bis_ons
bisques18236893bisques
bistres94017213bistres
bitches144117063bitches
caches137926913c_aches
caissons1036283caissons
calces104420053calc_es
calicoes123911593calicoes
canoes84725883c_anoes
cargoes104415223cargoes
cascades13128553cascades
caseose939163caseose
caseoses1039293caseoses
caseous9312513caseous
cases75048383cas__es
cashes114729883cas_hes
cashoos12310793cashoos
casques18278983casques
castes85631863cas_tes
castles94917733castles
castors94919443castors
catches144320773catches
cesses84221363ces_ses
cestodes1138203cestodes
cestos84718093cesto_s
chegoes1337333chegoes
chicles143512503chicles
chicos134614833chico_s
chigoes1338353chigoes
chinches18369363chinches
cibols1039523ci_bols
cicoree1149843ci_coree
cicorees1246413ci_corees
cilices113814023cilices
cimices13279803cimices
cinched153910863cinched
cineoles10109403cineoles
cineols9128853cineols
cines75239683ci__nes
cinques1837333cinques
cions75222853ci__ons
circle1039703circle_
circled1237583circled
circler1136423circler
circlers1235353circlers
circlet11311473circlet
circlets1235663circlets
circus104310593circ_us
circuses1238253circuses
cires74932913ci__res
cirques1836463cirques
cirrose937473cirrose
cirrous93111063cirrous
cissoid1037343cissoid
cissoids1145363cissoids
cisted95217523cis_ted
cistrons102710623cistrons
cists76624533cis__ts
cistus84611343cis_tus
cistuses1038283cistuses
cites74435593ci__tes
cities84524853ci_ties
citoles9312553citoles
citrons92913223citrons
citrous93112993citrous
civies114116443ci_vies
civvies1555843civvies
claroes93113733claroes
cliches144213743cliches
clinches153910363clinches
cloches144113713cloches
coaches144018693coaches
coccous1039003coccous
cocoas104915743c_ocoas
cocos95624693c_oco_s
conches144019813conches
condoes104319203condoes
congoes103617303congoes
cooches143515833cooches
coses76949493cos__es
coshes115022783cos_hes
cosies84932153cos_ies
cosines94122673cosines
cosmos10311753cosmo_s
cosmoses1239703cosmoses
couches144020473couches
couscous1246683couscous
creches14313093creches
crises84529433cris__es
cruces105117543cruc_es
cuishes122810823cuis_hes
cuisines1049373cuisines
cuisses9319883cuis_ses
culches143710743culches
curches143512743curches
cuscus1038113cusc_us
cuscuses1235863cuscuses
cusses84522773cus_ses
cussos84210003cusso_s
custodes1136653custodes
customs11348263customs
custos84014313custo_s
cutches143216463cutches
cycles1339303c_ycles
dices86434243di_c_es
dicots94915793di_cots
didoes85716963di_does
dildoes9229243dildoes
dingoes94114833dingoes
diploes101111493diploes
discase102912863discase
discases112014503discases
disced104914653disc_ed
disclose1148743disclose
discloses1249473discloses
disco85616073disco__
discoid11311243discoid
discoids1239873discoids
discord1139993discord
discords1238593discords
discover1439563discover
discovers1538153discovers
discs85316263disc__s
discus94512113disc_us
discuses113112863discuses
discuss10357953discuss
dishes104622653dis_hes
dismes95617673dis_mes
dispose10312763dispose
disposes11313823disposes
disrobes1139743disrobes
disses75225963dis_ses
distomes11314163distomes
disuses84015413disuses
disyokes1656503disyokes
ditches133215713ditches
episcopes1545803episcopes
escots84211743_escots
fasces114914543fasc_es
fescues1236783fescues
fiacres1237253fiacres
fiascos12124743fiasco_s
fices106031163fi_c_es
fiches145219533fi_ches
filches153410723filches
finches153914193finches
fiscals1238003fiscals
fiscs105311883fisc__s
fishes125221343fis_hes
fitches153516193fitches
frescoes1357833frescoes
fuscous1256673fuscous
gascons10289103gascons
gessoes838293gessoes
ginzoes1735433ginzoes
gismos957183gismo_s
gustoes879873gustoes
hilloes103815963hilloes
hisses94719353his_ses
hissies103915823hissies
histones11312803histones
hitches153616273hitches
ices66129643_i_c_es
icicles1135943icicles
icones84616383_i_cones
icons76516493_i_cons
inches114419673_inches
incogs937903_incogs
incomes11712373_incomes
isles54220563_is_les
issues648803_issues
istles62814983_istles
itches114916213_itches
jingoes153811443jingoes
juncoes16338073juncoes
kiddoes13387063kiddoes
kirsches1743843kirsches
kishkes1334773kishkes
kisses104217333kis_ses
kitsches1734073kitsches
lassoes74613853lassoes
liches114724293li_ches
lingoes84014693lingoes
lisles63416283lis_les
listees73416673listees
locoes85516583_locoes
mascons113411583mascons
mascots113910343mascots
miches134320733mi_ches
minces104420803minc_es
mischose1547253mischose
miscites12313783miscites
miscode12310413miscode
miscoded1437983miscoded
miscoin11311433miscoin
miscoins12311083miscoins
miscook1546473miscook
miscooks1645463miscooks
miscopies1549613miscopies
miscopy1636663miscopy
miscue10412223miscue_
miscued1239293miscued
miscuts1139183miscuts
misdoer1048633misdoer
misdoers1137103misdoers
mises74740563mis__es
mislies92922283mislies
mismoves1537293mismoves
misos76523293mis_o_s
misses85130873mis_ses
missies93423983missies
misuses93216023misuses
misyokes1735513misyokes
muscles11310563muscles
niches114419143ni_ches
nicols8810243ni_cols
nieces84112713niec_es
picots104616443pi_cots
pieces104217273piec_es
pinches144117933pinches
pingoes105116523pingoes
pinkoes135512313pinkoes
pintoes95117713pintoes
pisco96314983pisco__
pishes114722103pis_hes
pishoges1446953pishoges
pisos76021063pis_o_s
pisses84525083pis_ses
pistes85325633pis_tes
pistoles102514723pistoles
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
pitches143617753pitches
rescores105415693rescores
rescues9312753rescues
reshoes102316033reshoes
rices75536153ri_c_es
riches115022083ri_ches
rises55244043ris__es
rissoles839113rissoles
risuses73210923risuses
roscoe839763roscoe_
scissors1054353scissors
scones84521303__scones
scopes104719593__scopes
scops95820193__scops
scores84725923__scores
scots74025913__scots
scows106617803__scows
shoes85429663__shoes
sices75637273si_c_es
sises55233833sis__es
sisses64520603sis_ses
sissies73716603sissies
sitcoms1145533sitcoms
sloes54728873__sloes
tiptoes939173tiptoes
tisanes7311853tisanes
tissues737463tissues
tusches1237903tusches
vices105725533vi_c_es
visages1138693visages
viscoid1337023viscoid
viscus11428503visc_us
vises84427773vis__es
visions10311023visions
visors92912223vis_ors
wiches144418753wi_ches
winces114819113winc_es
winches154714373winches
winoes94317013wi_noes
wisdoms1335453wisdoms
wises85633193wis__es
wishes124920953wis_hes
wisses94619603wis_ses
witches152715793witches
zilches21326303zilches
zincous1837053zincous
zircons1854963zircons

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 Filter1786911340270.436409841.7
2DLD Change Limit1340273096.06322105.7
3Display Results3093090.1232512.2
 (SQL Overall)1786913096.62226984.4
 
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.