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

107 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
cassatas103668(None) 
cassabas1245731cassabas
cassata938141cassata_
cassavas1344801cassavas
canastas1037692canastas
cantatas103410092cantatas
casabas1139982ca_sabas
casavas1237822ca_savas
cascaras1237702cascaras
caseates10313712caseates
casitas93312042ca_sitas
cassaba1145662cassaba_
cassava1255002cassava_
cassenas10317482cassenas
cassias93514342cass_ias
cassinas103610642cassinas
albatas938373_albatas
asanas6514113_a_sanas
asramas938303_asramas
assagai843903_assagai
assagais943813_assagais
assails769093_assails
assais6711963_assa_is
assays977903_assa_ys
assets65617663_asset_s
balatas9311833ba_latas
basmatis1247343basmatis
bassets96414823basset_s
bassetts10407373bassetts
cabalas113516003ca_balas
cabanas112413033ca_banas
cabbalas1467373cabbalas
caesars9410733caesa_rs
caestus947773caes_tus
caesuras1055733caesuras
calamatas1345783calamatas
calisayas1442463calisayas
canasta938363canasta_
cantalas104013523cantalas
cantata93811813cantata_
caponatas1343903caponatas
capstan1137903caps_tan
capstans1257243capstans
carates95630613ca_rates
carats85929023ca_rat_s
caritas93316963ca_ritas
casaba1079263ca_saba_
casas75327843ca_s__as
casava1157873ca_sava_
casbahs1436463casba_hs
cascades13128553cascades
cascara1138313cascara_
caseases10410473caseases
caseate9314783caseat_e
caseated11310713caseated
casemates1349523casemates
casettes1039653casettes
cashaws15398573casha_ws
casita82913703ca_sita_
caskets133910173casket_s
cassation1197913cassation
cassations1276873cassations
cassena9287843cassena_
cassenes103611293cassenes
cassette1047813cassette
cassettes1146703cassettes
cassia83714763cass_ia_
cassina94113163cassina_
cassines103116613cassines
cassinos10309353cassinos
cassis84818853cass__is
cassises103811743cassises
cassocks1645033cassocks
castaway1664573castaway
castaways1743673castaways
castes85631863ca_s_tes
castrates11312673castrates
castratos1147633castratos
casts77237793ca_s_t_s
casuals91410533casua_ls
caudates11310263caudates
causals91411183causa_ls
caveats1239803caveat_s
cestas85018543c_es_tas
classmates1444503classmates
cossacks1645223cossacks
cossets95014283cosset_s
cuestas957933cues_tas
cushats12288273cushat_s
marsalas1038253marsalas
masalas9312053ma_salas
mascaras1237693mascaras
massages1159883massages
massas85116463mass__as
mastabas1246803mastabas
paisanas10288873paisanas
passades1139203passades
passados1146303passados
passages1139513passages
pastas85422873pa_s_tas
piassabas1342323piassabas
piassavas1442173piassavas
samsaras1045873samsaras
sassafras1251803sassafras
tassets75012773tasset_s
vassals1057953vassa_ls
wassails1145953wassails

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.420425454.8
2DLD Change Limit1461621076.61022112.3
3Display Results1071070.0333242.4
 (SQL Overall)1786911077.06325299.6
 
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.