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

62 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
cassaba1145661cassaba
casaba1079262ca_saba
cassabas1245732cassabas
cassata938142cassata
cassava1255002cassava
sassaby1244002sassaby
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assay8710283_assa_y
assays977903_assays
caesar8410933caesa_r
caesars9410733caesars
casa65630863ca_sa__
casabas1139983ca_sabas
casas75327843ca_sa_s
casava1157873ca_sava
casbah1337903casba_h
casbahs1436463casbahs
cascabel14174503cascabel
cascable141510623cascable
cascade12118603cascade
cascara1138313cascara
casease939323casease
caseate9314783caseate
cashable15159793cashable
cashaw14439793casha_w
cashaws15398573cashaws
cassatas1036683cassatas
cassavas1344803cassavas
cassena9287843cassena
cassene93111543cassene
cassia83714763cass_ia
cassias93514343cassias
cassina94113163cassina
cassine93817283cassine
cassino93512433cassino
cassis84818853cass_is
cassock1545953cassock
castable121613973castable
casual81112863casua_l
casuals91410523casuals
causable1239973causable
causal81413203causa_l
causals91411183causals
classable1347143classable
cossack1545823cossack
massa75518923massa__
massage1039893massage
massas85116463massa_s
mastaba1146223mastaba
passable12310633passable
passably1537253passably
passade1039233passade
passado1037053passado
passage1039803passage
passant9813943passant
piassaba1242433piassaba
vassal979243vassa_l
vassals1057953vassals
wasabi1154643wa_sabi
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.390458182.1
2DLD Change Limit134027626.76619808.9
3Display Results62620.0302066.7
 (SQL Overall)178691627.18624866.5
 
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.