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

227 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
caseases1041047(None) 
casease939321casease_
caseates10313711caseates
caseoses1039291caseoses
asepses946362_asepses
camases114216342ca_mases
canvases13349522canvases
capiases1239252capiases
carcases12313092carcases
caresses10314062caresses
cascades13128552cascades
caseate9314782caseate_
caseated11310712caseated
casefies1339212casefies
casemates1349522casemates
caseose939162caseose_
casernes103810752casernes
casettes1039652casettes
cassises103811742cassises
ceases84427072c__eases
creases94020962c_reases
diseases92415812diseases
miseases102614342miseases
abases85720773_a_bases
acariases1146613acariases
accesses1287493accesses
acreages1138373acreages
aliases7914493_aliases
anlases72514903_anlases
appeases1238663appeases
arrases71214543_arrases
asceses938623_asceses
asepsis985903_asepsis
askeses1136463_askeses
asperses104111673_asperses
aspises9611643_aspises
asses55629283_as__ses
assesses737383assesses
atlases72410643_atlases
avenses1049643_avenses
avgases11106313_avgases
baases85218013ba__ases
balases93815433ba_lases
baseless1099563baseless
baseness10910943baseness
basses85428303bas__ses
boreases10310253boreases
cabbages1537203cabbages
cabooses1237863cabooses
cactuses1237933cactuses
caddises12329353caddises
cadelles1139973cadelles
cadences1338473cadences
caesars9410733caesa_rs
caestuses1144893caestuses
calashes13310543ca_lashes
caleches15269943caleches
calesas9411833cale_sas
calloses10313393calloses
calluses1039323calluses
camass104114183ca_mas_s
camasses12388973camasses
camises114218463ca_mises
campuses1437773campuses
canapes111213083ca_napes
canewares1447363canewares
canvased14246223canvased
canvaser13276563canvaser
canvasers14265363canvasers
canvass12376873canvas_s
canvasses14286043canvasses
carafes125015703ca_rafes
carates95630613ca_rates
carcase11312743carcase_
carcass11310513carcas_s
carcasses1337483carcasses
cardcases1446513cardcases
careless102813633careless
caress85720263care_s_s
caressed1139163caressed
caresser1038813caresser
caressers1137443caressers
caretakes1547143caretakes
carfares13310323carfares
caritases1139763caritases
carnages11312213carnages
carouses10614503carouses
carses85233653ca__rses
cartages11313313cartages
carwashes1745783carwashes
casabas1139983cas_abas
casas75327843cas_a__s
casavas1237823cas_avas
casbahs1436463casba_hs
cascabel14174503cascabel
cascabels15163233cascabels
cascables15165773cascables
cascade12118603cascade_
cascaded14135703cascaded
cascaras1237703cascaras
casefied1445943casefied
caseinates1247443caseinates
caseins93115053case_ins
casemate1239843casemate_
casemated1446953casemated
caseous9312513case_ous
caserne93710063caserne_
caserns94711223case_rns
cases75048383c___ases
casette9310393casette_
cashaws15398573casha_ws
cashes114729883cas__hes
cashless1336773cashless
casques18278983cas_ques
cassabas1245733cassabas
cassatas1036683cassatas
cassavas1344803cassavas
cassenes103611293cassenes
cassettes1146703cassettes
cassines103116613cassines
cassis84818853cas__sis
castanet10416193castanet
castanets1146343castanets
casteisms1345253casteisms
castes85631863cas__tes
castles94917733cas_tles
castrates11312683castrates
casuals91410533casua_ls
casuists1036523casuists
catalases1149443catalases
catenates11311813catenates
cateress102311613cateress
catfaces1536963catfaces
catharses1446413catharses
caucuses1236783caucuses
caudates11310263caudates
causeless1135193causeless
causeries11510643causeries
causes88026473ca__uses
caveated1439133caveated
caveats1239803cavea_ts
caviares1337993caviares
cayennes1345013cayennes
cayuses12188403ca_yuses
cease75227653c__ease_
ceased94920783c__eased
ceaseless1135733ceaseless
censes83721803c__enses
cereuses1049243cereuses
cesses84221363c__esses
cestuses1038083cestuses
charases131312763charases
chases115128233c__hases
chasses124017503chas__ses
chastises1437703chastises
cheeses123613103c_heeses
chesses124112633c_hesses
cineastes1165563cineastes
cineasts1045543cineasts
cistuses1038283cistuses
classes94717943clas__ses
cleanses10358143c_leanses
cleaves124111623c_leaves
coleuses1039723coleuses
cosmoses1239713cosmoses
crases85532313c__rases
crease85519573c_rease_
creased104315593c_reased
creaser94415743c_reaser
creasers103612843c_reasers
creates95225203c_reates
creeses93914623c_reeses
cresses94219813c_resses
cuscuses1235863cuscuses
cusses84522773cus__ses
cutlases1038033cutlases
cycases1437533c_ycases
cyclases1537133cyclases
cyeses11510123c_ye_ses
czardases2143033czardases
danseuses1044133danseuses
deceases11410153deceases
diastases1047073diastases
discases112014503discases
disease83213843disease_
diseased103011713diseased
diseuses93112763diseuses
eases56041613___eases
elastases946113elastases
feases95422923__feases
gasses75724783gas__ses
greases84816713_greases
lactases1038523lactases
lampases1267293lampases
lasses64827593las__ses
leases65428113__leases
madrases112610003madrases
maleates103316343maleates
maltases1039693maltases
massages1159883massages
masses85028713mas__ses
masseuses1144793masseuses
misease92713043misease_
nauseates946213nauseates
obsesses1036223obsesses
pareses94718883pare_ses
passades1139203passades
passages1139513passages
passes86030473pas__ses
passuses1036773passuses
pastises103616053pastises
peases85229473__peases
pleases94515483_pleases
releases8313343releases
sasses64124393sas__ses
seises64026713__seises
senses63923943__senses
sepses84515883__sepses
stases64225563__stases
tasses64826763tas__ses
teases65426273__teases
tsetses785453_tsetses
uneases73316263_uneases
ureases74416723_ureases
wastages12109753wastages
wiseass1035823wiseas_s
wiseasses1244043wiseasses

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622277.14020470.9
3Display Results2272270.0932440.9
 (SQL Overall)1786912277.63923391.9
 
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.