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

271 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
ciceros115858(None) 
cicero1048501cicero_
ceros74726072__ceros
cheeros123711632cheeros
cicerone1247522cicerone
cicerones1347072cicerones
ciceroni1244852ciceroni
ciders94620092cider_s
citers85022982citer_s
dicers94720742dicer_s
dineros83812332dineros
micros104115362mic_ros
picaros11310892picaros
ricers84120992ricer_s
viceroy1544932viceroy
viceroys1644102viceroys
acerose9310893_acerose
acerous9513333_acerous
aiders74524633aider_s
aileron739833aileron
ailerons849853ailerons
aimers84621913aimer_s
airers64922313airer_s
aivers94822323aiver_s
bicarbs1336013bicarbs
biceps12447713bice_ps
bices95029963bice__s
bickers154316553bicker_s
bicorns11338763bicorns
bicron103710773bic_ron
bicrons113410473bic_rons
biders94822803bider_s
biers76225223bi_er_s
bikers124517553biker_s
biners85023633biner_s
biros75325133bi__ros
bistros92810983bistros
biters83925243biter_s
boleros9310293boleros
braceros12397723braceros
cabers105023923caber_s
cacaos104616183cac_aos
cagers95624193cager_s
cameos105818003came_os
cameras11313363cameras
cancerous1367533cancerous
cancers114018583cancer_s
caners84629203caner_s
capers105428143caper_s
carers85133963carer_s
caserns94711223caserns
caters85336503cater_s
caverns124510253caverns
cavers115026843caver_s
ceders93817673ceder_s
ceilers93912533ceiler_s
ceres75540013__ceres
cero66329453__cero_
cerous85821203__cerous
charros124312143charros
cheerios13317583cheerios
cheero114712933cheero_
cheers114518913cheer_s
chemos13311723c_hemos
cherts115617233c_herts
chicanos1595993chicanos
chicer134513603chicer__
chicos134614833chic__os
chiders135312943chider_s
chimeras15388833chimeras
chimeres153511313chimeres
chimers144515143chimer_s
chiros114617773c_hiros
churros12427583churros
cicadas1235993cicadas
cicalas1139303cicalas
cicelies1269753cicelies
cicely1338833cice_ly
cicoree1149843cicoree
cicorees1246413cicorees
cider84723313cider__
cigars9910723cigar_s
cinderous1247043cinderous
cinders104617763cinder_s
cinemas1138043cinemas
cineol8108203cine_ol
cineols9128853cineols
cinereous1144993cinereous
cinerin9313823cinerin
cinerins10414103cinerins
cines75239683cine__s
ciphers14379993cipher_s
circlers1235353circler_s
cires74932913ci__res
cirrose937473ci_rrose
cirrous93111063ci_rrous
cirrus8349173ci_rrus
ciscos104711133ci_scos
cisterns10369573cisterns
cistron9299883cistron
cistrons102710623cistrons
citer74827333citer__
cites74435593cite__s
citherns13338873citherns
cithers124315773cither_s
citreous1056853citreous
citron83112983ci_tron
citrons92913223ci_trons
citrous93112993ci_trous
citrus83610923ci_trus
citterns10318123citterns
civets115212543cive_ts
claros84015113c_laros
clerks12458843c_lerks
clickers163910203clicker_s
clivers123411753cliver_s
cockers153618333cocker_s
cocos95624693coc__os
coders95426983coder_s
coheres122917693coheres
coilers93619903coiler_s
coiners93620753coiner_s
comedos12329073comedos
comers105328083comer_s
concerns122710833concerns
concertos132711133concertos
concerts123016063concerts
cooers84324563cooer_s
copers104629843coper_s
corers85231073corer_s
covers114627963cover_s
coverts124813813coverts
cowers114625533cower_s
credos94612853c_redos
criers83918583crier_s
cuatros938273cuatros
cubers105318353cuber_s
cuckoos1585123cuckoos
curers84923193curer_s
cyclers1435873cycler_s
cyclos1338073cyc_los
cyders12398833cyder_s
decerns10119053decerns
deicers103612733deicer_s
dicer85426423dicer__
dices86434243dice__s
dickers144117663dicker_s
dikers114418793diker_s
dimerous1139323dimerous
dimers94321093dimer_s
dinero75612643dinero_
diners75525953diner_s
discerns1138163discerns
divers105024963diver_s
diverts114412033diverts
eiders74321363eider_s
eros45238453___eros
facers115519443facer_s
fibers114717523fiber_s
fices106031163fice__s
fifers125414923fifer_s
filers94623723filer_s
firers94922683firer_s
fivers124420923fiver_s
fixers165112983fixer_s
gibers95114663giber_s
giros65722653gi__ros
givers104817713giver_s
heros84930863__heros
heteros10312683heteros
hiders104919653hider_s
hikers135014353hiker_s
hirers94518063hirer_s
icebox1753083_icebox
ices66129643_ice__s
ichors11310423_ichors
ickers123914183icker_s
icterus936073icterus
inerts64517023_inerts
intros64215773_intros
jibers155912883jiber_s
jivers164515643jiver_s
juicers1636153juicer_s
kickers124013293kicker_s
kiers95320093ki_er_s
kiters105218593kiter_s
lacers85225253lacer_s
libers84721443liber_s
lickers134118253licker_s
lictors93212593lictors
liers55130403li_er_s
lifers95617843lifer_s
ligers75022043liger_s
likers104620913liker_s
liners65428853liner_s
liters65429883liter_s
livers94927823liver_s
lucerns935753lucerns
macers105321273macer_s
macros104017013mac_ros
micells11107683micells
micro94715993mic_ro_
micron103714283mic_ron
microns113814783mic_rons
milers84625163miler_s
mimeos104511543mime_os
mimers105520183mimer_s
mincers113714853mincer_s
miners84126633miner_s
misers85025703miser_s
miters84328783miter_s
mixers154513563mixer_s
nicer74618293nicer__
nickers134415093nicker_s
niters64624213niter_s
nitros64214123ni_tros
oilers64721193oiler_s
pacers105124543pacer_s
picaras11311283picaras
picaro10311323picaro_
piceous11310693piceous
pickers153718093picker_s
piecers114112253piecer_s
piers75926333pi_er_s
pikers124717393piker_s
pincers113916503pincer_s
pipers104318663piper_s
pricers113915063pricer_s
primeros12336883primeros
racers84725433racer_s
rezeros1647453rezeros
ricer74726613ricer__
rices75536153rice__s
riders74123903rider_s
rimers84522553rimer_s
risers64624783riser_s
rivers94626543river_s
secerns987733secerns
sices75637273sice__s
sickos125112033sic_kos
sivers95324153siver_s
sizers155215813sizer_s
slicers94114923slicer_s
spicers113815553spicer_s
tickers133617723ticker_s
tiers55526523ti_er_s
tigers75616513tiger_s
tilers63523503tiler_s
timers84420993timer_s
tiros54524893ti__ros
titers64526413titer_s
toreros7311343toreros
ulcerous1046163ulcerous
ulcers839383ulcer_s
vicars11712263vicar_s
vices105725533vice__s
victors123311183victors
videos104911373vide_os
viers85621953vi_er_s
viperous1347613viperous
vipers114914533viper_s
vireos94212453vire_os
vivers124717363viver_s
voicers12348993voicer_s
wickers164114703wicker_s
wincers123415363wincer_s
wipers115416083wiper_s
wirers94617893wirer_s
wiverns13366963wiverns
wivers125320803wiver_s
zeros144918113__zeros

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.470380193.6
2DLD Change Limit1340272716.69020033.9
3Display Results2712710.0903011.1
 (SQL Overall)1786912717.25024647.0
 
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.