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

154 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
casefies133921(None) 
casefied1445941casefied
basifies13310492basifies
caseases10410472caseases
caseates10313712caseates
caseins93115052case_ins
caseoses1039292caseoses
casernes103810752casernes
casettes1039652casettes
causeries11510642causeries
ceasefires1562162ceasefires
gasifies1238692gasifies
rarefies1138992rarefies
academies1444683academies
aeries64737783_a_eries
aperies9423203_aperies
asepses946363_asepses
baffies153612943ba_ffies
bakeries14312203bakeries
balefires1444813balefires
baselines1138603baselines
basified1437823basified
basifier1337313basifier
basifiers1445203basifiers
cabbies133115163ca_bbies
cachexies2364163cachexies
caddies113718383ca_ddies
cadelles1139973cadelles
cadences1338473cadences
cadencies1447323cadencies
cafes106426923ca__f_es
caffeines1743913caffeines
caffeins1645123caffeins
cagefuls1484343cagefuls
calcifies1638923calcifies
caleches15269943caleches
calories102919563calories
camelias12510313camelias
camelids1356943camelids
cammies134016483ca_mmies
campfires1844123campfires
canaries10318943canaries
candies104125613ca_ndies
canities101519263canities
canneries11313083canneries
canopies12311853canopies
capelins12311133capelins
carafes125015713caraf_es
carefree1346343carefree
caresses10314063caresses
caries85147623ca__ries
carnies94123963ca_rnies
carnifies1439903carnifies
carries94328013ca_rries
cascades13128553cascades
casease939323casease_
caseate9314783caseate_
caseated11310723caseated
casefy1436273casef__y
casefying1843753casefying
caseic103212373case_i_c
casein83216453case_i_n
casemates1349523casemates
caseose939163caseose_
caseous9312513case_ous
caserne93710063caserne_
caserns94711223case_rns
cases75048383cas___es
casette9310393casette_
cashes114729883cas__hes
cashier123713323cas_hier
cashiers13318883cas_hiers
casimires1344693casimires
casques18278983cas_ques
cassenes103611293cassenes
cassettes1146703cassettes
cassias93514343cas_sias
cassines103116613cassines
cassis84818853cas_si_s
cassises103811743cassises
castes85631863cas__tes
castles94917733cas_tles
catteries11815553catteries
catties94023053ca_tties
causerie1078273causerie_
cauteries11615403cauteries
cavefish1974853cavefish
cavefishes2143863cavefishes
cavies114525003ca__vies
cavities131412613cavities
cayennes1345013cayennes
ceasefire1472143ceasefire
celeries10316313celeries
chevies153511443c_hevies
cicelies1269753cicelies
cissies94116153cis_sies
citifies13310683citifies
clarifies1448633clarifies
classifies1555003classifies
coalifies1439113coalifies
codifies1439643codifies
comedies13311843comedies
cosies84932163cos__ies
coteries10422713coteries
creepies1239613creepies
dassies84418663das_sies
defies104624053__defies
easies64126633eas__ies
eateries8324323eateries
faeries104118993fa_eries
fakeries1559833fakeries
falsifies1545983falsifies
gaieties9310183gaieties
gaseities1047093gaseities
gaselier946973gaselier
gaseliers1044943gaseliers
gasified1336533gasified
gasifier1236273gasifier
gasifiers1344523gasifiers
gayeties1236883gayeties
japeries17311463japeries
lassies74420103las_sies
mashies12318253mas_hies
masteries111018513masteries
miseries10320403miseries
naperies10313903naperies
nasties73520493nas_ties
nazifies2036063nazifies
ossifies1177563ossifies
pacifies15311233pacifies
pasties94529813pas_ties
pastries101517423pastries
ramifies13310503ramifies
rarefied1245913rarefied
rarefier1135353rarefier
rarefiers1244023rarefiers
rarifies11311943rarifies
ratifies11313513ratifies
redefies12710163redefies
roseries8317323roseries
safeties1139163safeties
salifies11314793salifies
salsifies1247253salsifies
sassies74719263sas_sies
scarifies1439603scarifies
series64540973__series
taffies133012693ta_ffies
tassies74918933tas_sies
tepefies1346893tepefies
tumefies1345773tumefies
vaselines1246713vaselines
waffies163611443wa_ffies
wasteries121115363wasteries
wastries111212883wastries

Search took 10 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.420425454.8
2DLD Change Limit1461621548.91016404.3
3Display Results1541540.0602566.7
 (SQL Overall)1786911549.39019029.9
 
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.