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

511 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
citole831150(None) 
citola838391citola
citoles9312551citoles
cajole154011182cajole
cattle85118902cattle
cibol9512022cibol_
cibols1039522cibols
ciboule1145092ciboule
cicale10314502cicale
cineole91010002cineole
circle1039702circle
citable11313462citable
cite65640342cit__e
citolas939362citolas
cole66956112c__ole
creole8913732creole
cuittle946402cuittle
cuttle84113892cuttle
dipole91112852dipole
kittle104012172kittle
little63312162little
pinole83218782pinole
pistole92414312pistole
stole54928812_stole
title54721072tit_le
tittle63613322tittle
tole46052902__tole
vittle94711752vittle
acetone9310793acetone
acetose938843acetose
acinose938583acinose
aioli5318313ai_oli
airhole1048273airhole
aisle55223193ai_sle
amitrole1045173amitrole
amole75724593_amole
anisole71010833anisole
anole55330383_anole
areole61017283areole
atoll57913923_atoll
atone56527983_atone
azole145118033_azole
battle85217863battle
bible95119423bi_ble
bifold1237223bifold
bile66147183bi__le
bindle94516263bindle
binocle1136493binocle
biome94916993bi_ome
biotope1146623biotope
birle75023633bi_rle
bitable11312203bitable
bite66547003bit__e
bizone1738603bizone
bole66448693__bole
bottle84916073bottle
bricole112810493bricole
brittle9168603brittle
butle75023103but_le
cable95329913c_able
cackle143416923cackle
cajoled17428283cajoled
cajoler16398393cajoler
cajoles163712103cajoles
camisole1246173camisole
candle94321483candle
canoe75627253cano_e
canola8313623canola
cantle84522153cantle
capitol11258283capitol_
capitols12247333capitols
capote10315733capote
cariole9818343cariole
carle74535703c_arle
carol75128613carol_
caroled103717693caroled
caroler93816753caroler
caroli85918233caroli
carols85124983carols
castle84918963castle
catalo8314853catalo
cate66254603cat__e
cathode1338993cathode
cattie85221023cattie
caudle93912913caudle
cenote83715843cenote
centile94217183centile
cestode1037963cestode
cetane8315283cetane
cete64934783cet__e
chicle134312543chicle
chigoe1237533chigo_e
chile105626893c_hile
chinone12510153chinone
chipotle1543653chipotle
chital114313883chital_
chiton112612393chito_n
chitons122611913chitons
choke145118023c_hoke
chola104718033c_hola
choler113717153c_holer
cholo105217973c_holo
choose115116143choose
chore105126763c_hore
chose105925403c_hose
chrome133214813chrome
chyle134913483c_hyle
ciao64924183ciao__
ciboules1244533ciboules
cicala10310053cicala
cicely1338833cicely
cicoree1149843cicoree
cilice103213353cilice
cine66242943ci__ne
cineol8108203cineol_
cineoles10109403cineoles
cineols9128853cineols
cinque1736853cinque
cion613330913ci_o_n
cions75222853ci_ons
cipolin1148783cipolin
circled1237583circled
circler1136423circler
circles1139903circles
circlet11311473circlet
cire65836373ci__re
cirque1735853cirque
cirrose937473cirrose
citadel1044383citadel
citeable1238413citeable
cited84421953cit_ed
citer74827333cit_er
citers85022983citers
cites74435593cit_es
cither114616683cither
cithren12306593cithren
citied94014143citied
cities84524853cities
citify1437443citify
citing94220183citing
citizen1845713citizen
citral81113893citral
citrals91111673citrals
citrate92216803citrate
citric102812313citric
citrin82615413citrin
citrine92514023citrine
citron83112983citron
citrons92913223citrons
citrous93112993citrous
citrus83610923citrus
city95122623cit__y
civie103716353ci_vie
civil103411933civil_
cleome1039083cleome
clone75728163c_lone
close76425223c_lose
clothe114712993clothe
clove105619443c_love
cloze165517543c_loze
cobble123615263cobble
coble94823173c_oble
cockle143913573cockle
coddle104713853coddle
code77347733c__ode
coffle14359043coffle
coital84117053coital_
coke107038383c__oke
col59360353c__ol_
cola66541393c__ola
cold77338773c__old
coled85540763c__oled
coles76055063c__oles
colone85425003colone
cols66553083c__ols
colt67158243c__olt
coly96940533c__oly
come87547703c__ome
comose105016843comose
condole102914953condole
cone67256963c__one
console92715983console
cooee74531023c_ooee
cool66940493c_ool_
cooled95224593c_ooled
cooler84824713c_ooler
coolie83821603c_oolie
cools75632633c_ools
cooly105525423c_ooly
cootie84223093cootie
cope86847383c__ope
core67263113c__ore
cote66648733c__ote
cottae84615703cottae
cotype1346823cotype
couple104415963couple
cove95837073c__ove
coyote11411783coyote
cradle93313163cradle
creoles9913323creoles
crimple13408693crimple
cringle103010353cringle
crinkle13359413crinkle
cripple13378583cripple
crone75231333c_rone
crore74922873c_rore
croze164719453c_roze
cuddle104414533cuddle
cuittled1133993cuittled
cuittles1045903cuittles
cupola10317693cupola
cupule103410723cupule
curdle95514313curdle
curule83614123curule
cute66440453cut__e
cutely115312803cutely
cuticle1138233cuticle
cutie76925933cut_ie
cutler84718033cut_ler
cutlet84924363cut_let
cutoff1436563cutoff
cutout8315923cutout
cutover1235283cutover
cuttled10319933cuttled
cuttles93613923cuttles
cycle1239523c_ycle
cymol1287623cymol_
cymols1377193cymols
cymose13429653cymose
cyton101511463cyto_n
cytons111710183cytons
dhole95215363_dhole
diastole947563diastole
diazole1736793diazole
dibble114013843dibble
diddle94915213diddle
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
diode74716113di_ode
diol57329133di_ol_
diols65521013di_ols
diploe9810153diploe
dipoles101013753dipoles
distome10313233distome
dite55547553dit__e
dole56550003__dole
dottle74212503dottle
ecotone938583ecotone
eidola737683eidola
epitome1157743epitome
epitope1147053epitope
etoile6312263_etoile
extol1247893extol_
extoll1334863extoll
extols1337683extols
fettle93713123fettle
fickle153912973fickle
fictile1238023fictile
fiddle113613383fiddle
file75446643fi__le
fille84327403fi_lle
filose96112503filose
fimble133611753fimble
finale94116763finale
fipple13329063fipple
fitly115114973fit_ly
fizzle17369713fizzle
footle93914383footle
frijole1734583frijole
futile93914953futile
giggle94313513giggle
gigolo836533gigolo
girdle82110463girdle
girolle835793girolle
gite55438613git__e
guttle74111973guttle
haole84820083_haole
higgle113811743higgle
hirple11158973hirple
hirsle9159573hirsle
histone10312843histone
hole77553393__hole
icicle1036583icicle
idle55423763_i_dle
idol56818633_idol_
idols65514133_idols
indole74516053indole
ingle64120433_ingle
inkle94515833_inkle
insole63515863insole
intone61115433intone
irone55126363_irone
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jiggle153811993jiggle
jingle143815223jingle
jole117233823__jole
ketol95414003ketol_
ketols104210763ketols
ketone105014533ketone
ketose105711813ketose
kettle104311613kettle
kibble143910953kibble
kindle114414233kindle
kirtle10309473kirtle
kite85338243kit__e
kithe125917453kit_he
kittel10368873kittel
kittled12388193kittled
kittler11338163kittler
kittles113012493kittles
liable81415813liable
ligule74010833ligule
lintol6369473lintol_
lintols7339553lintols
lisle53916723li_sle
lite47054543lit__e
lithe84922013lit_he
litotes7311183litotes
litre55421463lit_re
littler7348553littler
littles73212783littles
metol75917813metol_
metols84115773metols
metope10611123metope
mettle83815723mettle
mickle143715133mickle
middle103414983middle
midsole1037813midsole
miggle104012113miggle
mile66352573mi__le
mille75029133mi_lle
mingle93518783mingle
mite66249413mit__e
mitogen1036963mitogen
mitoses9312183mitoses
mitre75522423mit_re
mizzle16279993mizzle
mole66251833__mole
motile83818343motile
mottle84116053mottle
mutule8311423mutule
nettle64514583nettle
nibble103713283nibble
nickle123814483nickle
nicol71113293nicol_
nicols8810243nicols
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
nite45943583nit__e
niton55418283nito_n
nitons64614903nitons
nitre57519683nit_re
nitrile73011373nitrile
obole75917143_obole
oilhole1046263oilhole
ole37155213___ole
oriole6814293oriole
osmole8128513osmole
ostiole739013ostiole
otiose639403otiose
outsole71013433outsole
parole84425253parole
petiole9311303petiole
pettle84116053pettle
pickle144215653pickle
piddle103514913piddle
piehole12188553piehole
piffle14418233piffle
pile65649693pi__le
pilose84514243pilose
pilule8411123pilule
pimple123512963pimple
pinhole122010433pinhole
pinocle1138143pinocle
pinoles93418703pinoles
pintle83818263pintle
piolet83225643pi_olet
pistol83313333pistol_
pistoled11259593pistoled
pistoles102514723pistoles
pistols93213983pistols
piton76121583pito_n
pitons85319043pitons
pizzle16279493pizzle
pole65951303__pole
posole8314223posole
pothole12312173pothole
pottle84416103pottle
pozole1758913pozole
prole74527793_prole
rathole10312053rathole
rattle64717613rattle
resole64624183resole
retile65929673retile
retold73013753retold
retore67630773retore
ribose839893ribose
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533ri__le
rille55728733ri_lle
rimose8310593rimose
rimple103814583rimple
ripple103413913ripple
rissole739783rissole
rite45849453rit__e
role45851823__role
rootle63214453rootle
rutile65217683rutile
scuttle936463scuttle
setose65114773setose
settle63915663settle
sickle124418323sickle
sidle65124033si_dle
simile83115633simile
simple104315173simple
single74520603single
site47052413sit__e
sizzle14309613sizzle
skatole1135693skatole
skittle1135533skittle
sole46053673__sole
sotol54917653sotol_
sotols63714473sotols
spittle937923spittle
stale55637103_stale
stele55026843_stele
stifle93611903stifle
stile54931573_stile
stoae55024263_stoae
stoke94922513_stoke
stoled74521593_stoled
stolen64315063_stolen
stoles63927673_stoles
stone55431183_stone
stope74727243_stope
store56333813_store
stove85220253_stove
style85519363_style
systole1035763systole
tale46154163__tale
tattle64115653tattle
tele45040873__tele
thole85620843_thole
tickle124616743tickle
tile45451443__tile
tingle74319063tingle
tinkle103714453tinkle
tipple103411913tipple
tiptoe838283tipto_e
tithe85319703tit_he
titled73815003tit_led
titles63719923tit_les
titre54619393tit_re
tittie63213153tittie
tittles73413253tittles
toe310166853__to_e
toile54626493__toile
toke86738493__toke
tola45236333__tola
told56132203__told
toled65934923__toled
toles55147133__toles
toll45535263__toll
tolu45529153__tolu
tome67543193__tome
tone46953743__tone
tootle62613813tootle
tope65946383__tope
tore47359323__tore
tote46643673__tote
tritone73613883tritone
tule45735873__tule
untold7149683untold
uptore8279453uptore
utile54718933_utile
viable111613773viable
vile76139803vi__le
viol76523593vi_ol_
viola85915543vi_ola
violet92620923vi_olet
viols86118103vi_ols
virile9313433virile
vitae84217633vit_ae
vital84819673vital_
vitals94514303vitals
vittae93911003vittae
vittled11347343vittled
vittles103211113vittles
vole75236983__vole
wattle94314213wattle
whittle13106103whittle
whole114418093_whole
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimble133211923wimble
wimple133611363wimple
windle104617953windle
winkle133812833winkle
wintle94014603wintle
wite75443273wit__e
withe115220233wit_he
wittol935923wittol_
wittols1035733wittols
zizzle13247313zizzle

Search took 6 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.390458182.1
2DLD Change Limit1127165115.34321096.0
3Display Results5115110.1703005.9
 (SQL Overall)1786915115.90330271.2
 
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.