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

236 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
caseose93916(None) 
casease939321casease
caseoses1039291caseoses
caboose1138272caboose
callose9313662callose
cameos105818002cameos_
caseases10410472caseases
caseate9314782caseate
caseous9312512caseous
caserne93710062caserne
cases75048382case_s_
casette9310392casette
paseos88015812paseos_
acarbose1244683acarbose
acaulose1044383acaulose
acerose9310903acerose
acetose938843acetose
acinose938583acinose
aldose7311093_aldose
appose10411993_appose
arenose7311373_arenose
areole61017283_areole
ariose64818723_ariose
arkose104911343_arkose
arose55832083_a_rose
asepses946363_asepses
ashore9414613_ashore
askos95011773_askos_
aslope839013_aslope
aslosh966233_aslosh
asperse94210663_asperse
averse95811183_averse
bases75644353base_s_
basest84720493base_st
bassos85313703bassos_
cabers105023923cabers_
cabezone2144433cabezone
cabooses1237863cabooses
cacaos104616183cacaos_
cadelle1039923cadelle
cadence1239063cadence
cades85440733cade_s_
cadets96316513cadets_
caeoma1039033ca_eoma
cafes106426923cafe_s_
cagers95624193cagers_
cages85936013cage_s_
cajole154011183ca_jole
cakes116037673cake_s_
caleche14297953caleche
calesa8412473cale_sa
calloses10313393calloses
calos74431903ca_los_
calzone1848623calzone
camels105217083camels_
cameo95924993cameo__
cameoed1238383cameoed
camerae11312063camerae
cames97047313came_s_
camise103319633ca_mise
camos95927613ca_mos_
campos125217953campos_
caners84629203caners_
canes75350373cane_s_
canoe75627253ca_no_e
canoes84725883canoes_
cansos84915383cansos_
cantos84826973cantos_
canzone1858813canzone
capers105428143capers_
capes95441923cape_s_
capos94826073ca_pos_
capote10315733ca_pote
capstone1237653capstone
carbos105122263carbos_
carcase11312743carcase
carers85133963carers_
cares77369183care_s_
caress85720263care_ss
caressed1139173caressed
caresser1038813caresser
caresses10314063caresses
carets85330773carets_
cargoes104415223cargoes
cargos94619183cargos_
cariole9818343cariole
carouse9614423carouse
carse74934333ca__rse
carses85233653carse_s_
casas75327843cas_as_
cascade12118603cascade
case65848083ca___se
caseated11310723caseated
caseates10313713caseates
casebook1644453casebook
cased86032413case__d
casefied1445943casefied
casefies1339213casefies
casefy1436273case_fy
caseic103212373case_ic
casein83216453case_in
caseins93115053caseins
caseload1145623caseload
casemate1239843casemate
casern84713313case_rn
casernes103810753casernes
caserns94711223caserns
casettes1039653casettes
casework1746773casework
caseworm1546173caseworm
cashes114729883cashes_
cashews15428603cashews_
cashoo11312253casho_o
cashoos12310793cashoos
casinos93512833casinos_
caskets133910173caskets_
casks115720063cas_ks_
casque17299273cas_que
casques18278983casques
cassene93111543cassene
cassenes103611293cassenes
casserole1144403casserole
cassette1047813cassette
cassine93817283cassine
cassis84818853cassis_
cassises103811743cassises
cassock1545953cassock
caste75932363cas__te
casteism1247073casteism
casters94729903casters_
castes85631863castes_
castle84918963cas_tle
castles94917733castles
castoff1547793castoff
castor84418533casto_r
castors94919443castors
casts77237793cas_ts_
casuist9411303casuist
casus76419253cas_us_
catenae9311373catenae
caters85336503caters_
cates75951893cate_s_
cathode1338993cathode
cathouse1338863cathouse
cause75225353ca__use
causerie1078273causerie
causers94014793causers_
causes88026473cause_s_
causeys12387223causeys_
cavers115026843cavers_
caves105639703cave_s_
cayenne1244603cayenne
cayuse11207763ca_yuse
cease75227653c__ease
ceases84427073cease_s_
cense75121403c__ense
cestode1037963cestode
cestos84718093cestos_
chasers123714923chasers_
chases115128233chase_s_
chasse115114603chas__se
chastise1348173chastise
cheese113812763c_heese
choose115116143c_hoose
chose105925403c__hose
cineole91010003cineole
cirrose937473cirrose
ciscoes113610733ciscoes
ciscos104711133ciscos_
cleome1039083c_leome
close76425223c__lose
comose105016853c_omose
compose135716663compose
conenose1078593conenose
cosecs105015213cosecs_
coses76949493cose_s_
cosets85824403cosets_
coseys115215813coseys_
cosmos10311753cosmos_
cosmoses1239713cosmoses
crases85532313crase_s_
crease85519573c_rease
creese84014333c_reese
creole8913733c_reole
crustose1045503crustose
cusecs10509153cusecs_
cussos84210003cussos_
custos84014313custos_
cymose13429653c_ymose
danseuse942893danseuse
disease83213843disease
diseuse83110723diseuse
dispose10312763dispose
easels65914553easels_
eases56041613ease_s_
gaseous839503gaseous
gases65633993gase_s_
gashouse1245693gashouse
lactose969493lactose
lanose6313593la_nose
lasers64925703lasers_
lases54944763lase_s_
lassoes74613853lassoes
lassos64913813lassos_
maltose939793maltose
mannose939243mannose
masers84623453masers_
masse75125293mas__se
masseuse1044253masseuse
misease92713043misease
narcose95910393narcose
oases55330983oase_s_
osmose8108003_osmose
papoose1147513papoose
pappose1047413pappose
pareos87023773pareos_
paseo77022513paseo__
pases75346503pase_s_
passe75525693pas__se
racemose1245003racemose
ramose8314403ra_mose
rasers64526783rasers_
rases55447213rase_s_
scapose1147753sca_pose
scariose1037593scariose
seise54727853__seise
sense55526823__sense
setose65114773__setose
talcose938143talcose
tasse54821843tas__se
tsetse664693_tsetse
vadose1037963va_dose
vamoose1235863vamoose
vamose1159283va_mose
vases84626263vase_s_
viscose1237863viscose

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272367.65617506.1
3Display Results2362360.0932537.6
 (SQL Overall)1786912368.17221866.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.