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 “casease” 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
casease93932(None) 
caseases10410471caseases
caseate9314781caseate
caseose939161caseose
carcase11312732carcase
casas75327842cas_as_
cascade12118602cascade
caseated11310712caseated
caseates10313702caseates
casemate1239842casemate
caseoses1039292caseoses
caserne93710062caserne
cases75048382case_s_
casette9310392casette
cease75227652c__ease
crease85519572c_rease
disease83213842disease
misease92713042misease
abase76023483_a_base
acreage1037833acreage
appease1137913appease
areae55229743_area_e
areas55935773_areas_
asea46327183_asea__
asepses946363_asepses
asperse94210663_asperse
averse95811183_averse
bases75644353base_s_
basest84720493base_st
cabbage1446983cabbage
cabers105023903cabers_
caboose1138273caboose
cacas95627983ca_cas_
cadelle1039913cadelle
cadence1239063cadence
cades85440733cade_s_
cadets96316503cadets_
caesar8410933caesa_r
caesars9410723caesars
cafes106426923cafe_s_
cagers95624183cagers_
cages85936013cage_s_
cakes116037673cake_s_
calash11312433ca_lash
calceate1239863calceate
caleche14297943caleche
calesa8412473cale_sa
calesas9411823calesas
callas84526753callas_
callose9313653callose
camas96333523ca_mas_
camases114216343ca_mases
camass104114183ca_mass
camels105217083camels_
cameos105818003cameos_
camerae11312043camerae
cameras11313343cameras_
cames97047313came_s_
camise103319633ca_mise
canape10913513ca_nape
caners84629193caners_
canes75350373cane_s_
caneware1347803caneware
cannas84518403cannas_
canvas113813333canvas_
canvased14246213canvased
canvaser13276553canvaser
canvases13349513canvases
canvass12376873canvass
capers105428133capers_
capes95441923cape_s_
capias10318353capias_
capiases1239253capiases
carafe115416163ca_rafe
carate84734003ca_rate
carcases12313083carcases
carcass11310513carcass
cardcase1345963cardcase
carers85133953carers_
cares77369183care_s_
caress85720263care_ss
caressed1139163caressed
caresser1038803caresser
caresses10314063caresses
caretake1446773caretake
carets85330773carets_
carfare12310073carfare
carnage10311743carnage
carouse9614423carouse
carpale113414353carpale
carse74934333ca__rse
carses85233653carse_s_
cartage10312593cartage
carwash1535993carwash
casa65630863cas_a__
casaba1079263cas_aba
casabas1139983casabas_
casava1157873cas_ava
casavas1237813casavas_
casbah1337903casba_h
casbahs1436463casbahs
cascabel14174503cascabel
cascable141510623cascable
cascaded14135703cascaded
cascades13128553cascades
cascara1138313cascara
case65848083c___ase
cased86032413case__d
casefied1445943casefied
casefies1339213casefies
casefy1436273case_fy
caseic103212373case_ic
casein83216453case_in
caseinate1148243caseinate
caseins93115053caseins
casemated1446953casemated
casemates1349513casemates
caseous9312513caseous
casern84713313case_rn
casernes103810753casernes
caserns94711213caserns
casettes1039653casettes
cashable15159793cashable
cashaw14439793casha_w
cashaws15398573cashaws
cashes114729883cashes_
cashews15428603cashews_
casitas93312043casitas_
caskets133910173caskets_
casks115720063cas_ks_
casque17299273cas_que
casques18278983casques
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassenas10317483cassenas_
cassene93111543cassene
cassenes103611293cassenes
cassette1047813cassette
cassias93514343cassias_
cassine93817283cassine
cassis84818853cassis_
cassises103811743cassises
castable121613973castable
castanet10416193castanet
caste75932363cas__te
casteism1247073casteism
casters94729893casters_
castes85631863castes_
castle84918963cas_tle
castles94917733castles
castrate10313863castrate
casts77237793cas_ts_
casual81112863casua_l
casuals91410523casuals
casuist9411303casuist
casus76419253cas_us_
catalase1039213catalase
catenae9311363catenae
catenas9313103catenas_
catenate10312833catenate
caters85336493caters_
cates75951873cate_s_
catface1436763catface
caudate10311353caudate
cause75225353ca__use
causerie1078263causerie
causers94014783causers_
causes88026473cause_s_
causeys12387223causeys_
caveat11417723cavea_t
caveated1439133caveated
caveats1239803caveats
cavers115026833cavers_
caves105639703cave_s_
caviare1238373caviare
cayenne1244603cayenne
cayuse11207763ca_yuse
ceased94920783c__eased
ceases84427073c__eases
cense75121403c__ense
cestas85018543cestas_
chase105127123c__hase
chaseable1646343chaseable
chasers123714893chasers_
chases115128233chase_s_
chasse115114603chas__se
chastise1348173chastise
cheese113812763c_heese
cineast9310523cineast
cineaste1045743cineaste
cleanse9358723c_leanse
cleave114212513c_leave
cosecs105015213cosecs_
coses76949493cose_s_
cosets85824403cosets_
coseys115215813coseys_
costae85319683costa_e
costate94019273costate
crases85532313crase_s_
creased104315583c_reased
creaser94415723c_reaser
creases94020963c_reases
creasy114612303c_reasy
create85126373c_reate
creese84014333c_reese
cuneate9311723cuneate
cusecs10509153cusecs_
cuspate1138233cuspate
cyclase1436613cyclase
danseuse942893danseuse
decease1049523decease
diastase946593diastase
discase102912863discase
diseased103011703diseased
diseases92415813diseases
diseuse83110713diseuse
ease45042333___ease
easels65914553easels_
eases56041613ease_s_
elastase845643elastase
fease84824873__fease
galeae74717453galea_e
galeas74618503galeas_
galeate83916783galeate
gases65633993gase_s_
grease75416233_grease
hastate10313913hastate
kashas133311903kashas_
lactase937953lactase
lasers64925703lasers_
lases54944763lase_s_
lease55230263__lease
maleate94117543maleate
maltase938903maltase
masas75630413mas_as_
masers84623453masers_
massage1039893massage
massas85116463massas_
masse75125293mas__se
masseuse1044253masseuse
miseases102614343miseases
nauseas735993nauseas_
nauseate845893nauseate
oases55330983oase_s_
paleae84820293palea_e
paleate94120003paleate
paseos88015813paseos_
pases75346503pase_s_
pashas115117063pashas_
passade1039233passade
passage1039803passage
passe75525693pas__se
pastas85422873pastas_
pease75231113__pease
please84315733_please
rasers64526783rasers_
rases55447213rase_s_
release7312763release
roseate7613453roseate
seas45755273__seas_
seise54727853__seise
sense55526823__sense
tasse54821843tas__se
tease55428713__tease
tsetse664693_tsetse
unease63816643_unease
urease64516993_urease
vases84626263vase_s_
wastage11109253wastage
wiseass1035823wiseass

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.1561145455.1
2DLD Change Limit1340272716.79619721.5
3Display Results2712710.0932914.0
 (SQL Overall)1786912717.04525364.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.