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

83 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
cassava125500(None) 
casava1157871ca_sava
cassaba1145661cassaba
cassata938141cassata
cassavas1344801cassavas
casaba1079262ca_saba
casavas1237822ca_savas
cascara1138312cascara
cassabas1245732cassabas
cassatas1036682cassatas
cassena9287842cassena
cassia83714762cass_ia
cassina94113162cassina
piassava1342252piassava
asana5315483_a_sana
asrama839193_asrama
assagai843903_assagai
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assay8710283_assa_y
assays977903_assays
baklava1643103baklava
cabala103516913ca_bala
cabana103913563ca_bana
cabbala1367183cabbala
caesar8410933caesa_r
caesars9410733caesars
caesura956233caesura
calisaya1342623calisaya
canasta938363canasta
cantala94114673cantala
cantata93811813cantata
caravan1239233ca_ravan
casa65630863ca_s__a
casabas1139983ca_sabas
casas75327843ca_sa_s
casbah1337903casba_h
casbahs1436463casbahs
cascade12118603cascade
cascaras1237703cascaras
casease939323casease
caseate9314783caseate
cashaw14439793casha_w
cashaws15398573cashaws
casita82913703ca_sita
cassenas10317483cassenas
cassene93111543cassene
cassias93514343cassias
cassinas103610633cassinas
cassine93817283cassine
cassino93512433cassino
cassis84818853cass_is
cassock1545953cassock
castaway1664573castaway
casual81112863casua_l
casuals91410523casuals
causal81413203causa_l
causals91411183causals
cossack1545823cossack
dissave1139413dissave
marsala939583marsala
masala8311813ma_sala
mascara1138023mascara
massa75518923mass__a
massage1039893massage
massas85116463massa_s
massive12289773massive
mastaba1146223mastaba
paisana94010223paisana
passade1039233passade
passado1037053passado
passage1039803passage
passant9813943passant
passive12239593passive
piasava1243883piasava
piassaba1242433piassaba
piassavas1442173piassavas
samsara936913samsara
sassaby1244003sassaby
vassal979243vassa_l
vassals1057953vassals
wassail1056133wassail

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.403443402.0
2DLD Change Limit134027836.62620227.4
3Display Results83830.0302766.7
 (SQL Overall)178691837.05925313.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.