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 “cassaba” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
cassaba114566(None) 
casaba1079261ca_saba
cassabas1245731cassabas
cassata938141cassata
cassava1255001cassava
casabas1139982ca_sabas
casava1157872ca_sava
cascara1138312cascara
cassatas1036682cassatas
cassavas1344802cassavas
cassena9287842cassena
cassia83714762cass_ia
cassina94113162cassina
mastaba1146222mastaba
piassaba1242432piassaba
sassaby1244002sassaby
asana5315483_a_sana
asrama839193_asrama
assagai843903_assagai
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assay8710283_assa_y
assays977903_assays
cabala103516913ca_bala
cabana103913563ca_bana
cabbala1367183cabbala
cabomba1544083cabomba
caesar8410933caesa_r
caesars9410733caesars
caesura956233caesura
calisaya1342623calisaya
canasta938363canasta
cantala94114673cantala
cantata93811813cantata
carabao1139673ca_rabao
caramba1336893caramba
carnauba1252733carnauba
casa65630863ca_s__a
casas75327843ca_sa_s
casavas1237823ca_savas
casbah1337903casba_h
casbahs1436463casbahs
cascabel14174503cascabel
cascable141510623cascable
cascade12118603cascade
cascaras1237703cascaras
casease939323casease
caseate9314783caseate
cashable15159793cashable
cashaw14439793casha_w
cashaws15398573cashaws
casita82913703ca_sita
cassenas10317483cassenas
cassene93111543cassene
cassias93514343cassias
cassinas103610643cassinas
cassine93817283cassine
cassino93512433cassino
cassis84818853cass_is
cassock1545953cassock
castable121613973castable
castaway1664573castaway
casual81112863casua_l
casuals91410533casuals
catawba1443703catawba
causable1239973causable
causal81413203causa_l
causals91411183causals
classable1347143classable
cossack1545823cossack
marsala939583marsala
masala8311813ma_sala
mascara1138023mascara
massa75518923mass__a
massage1039893massage
massas85116463massa_s
mastabah1554023mastabah
mastabas1246803mastabas
paisana94010223paisana
passable12310633passable
passably1537253passably
passade1039233passade
passado1037053passado
passage1039803passage
passant9813943passant
piasaba1144193piasaba
piassabas1342323piassabas
piassava1342253piassava
samsara936913samsara
vassal979243vassa_l
vassals1057953vassals
wasabi1154643wa_sabi
wassail1056133wassail

Search took 7 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.453394461.4
2DLD Change Limit134027946.36021073.4
3Display Results94940.0303133.3
 (SQL Overall)178691946.84326113.0
 
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.