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

77 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
sanddab114492(None) 
sanddabs1243901sanddabs
sandal73317282san_dal
sandbag11106242sandbag
sandbar10108192sandbar
sandman10310172sandman
addax1435993_a_ddax
anodal72512123_anodal
banda85223113ban_da_
bandas95120543ban_das
bandeau1038523bandeau
bandsaw1334803bandsaw
candida114110253candida_
candidal12367743candidal
candidas12338653candidas
granddad1244253granddad
granddam1344693granddam
handax1749583han_dax
handbag1495863handbag
handcar1337373handcar
handsaw1435533handsaw
landau7310613lan_dau
landgrab1243033landgrab
landman1038923landman
panada94113053panada_
panadas103312213panadas
panda85022613pan_da_
pandas95521963pan_das
randan7315253ran_dan
sadden83212403sa_dden
sadder82916973sa_dder
saddhu1133413sa_ddhu
saddle83915493sa_ddle
sancta839833sancta_
sand55338473san_d__
sandable111612823san_dable
sandals82715203sandals
sandarac1145833sandarac
sandbags1296373sandbags
sandbank1544873sandbank
sandbars11108783sandbars
sandbox1744803sandbox
sandbur10105353sandbur
sanded84920613san_ded
sander74828533san_der
sanders84025943sanders
sandfly1435643sandfly
sandhi1038193san_dhi
sandhis1139993sandhis
sandhog1275453sandhog
sandier84017843sandier
sanding93520603sanding
sandlot8311693sandlot
sandmen1039413sandmen
sandpit1049633sandpit
sands65228583san_d_s
sandsoap1143723sandsoap
sandy94221133san_d_y
saned65636273saned__
sanga66023803san_ga_
sangar73617693san_gar
sangas75222663san_gas
sanjak1735693san_jak
sansar63613403san_sar
sardar73013183sa_rdar
scandal1038673scan_dal
scandia1038063scandia_
scandias1137863scandias
sendal73314993sen_dal
serdab937833s_erdab
standpat1145723standpat
sundae7312873sun_dae
sundial859863sundial
synodal1145743synodal
vanda94515923van_da_
vandal103713833van_dal
vandas103915993van_das

Search took 9 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.440406115.9
2DLD Change Limit134027777.75017293.8
3Display Results77770.0302566.7
 (SQL Overall)178691778.22021738.6
 
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.