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

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

84 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
salads7531696(None) 
salad65321831salad_
salals65120081salals
alands75418372_alands
alans55636172_alans
alas46358122_ala_s
balas76937212bala_s
balds85524642bal_ds
ballads104212912ballads
clads85722732_clads
farads104713272farads
galahs105512682galahs
galas65731642gala_s
glads75620612_glads
halals95018312halals
halids104016132halids
jalaps15299182jalaps
kalams12310602kalams
lads56549132__lads
malady1237862malady
malars85020682malars
naiads739012naiads
nalas55528362nala_s
naleds7469132naleds
palais8420422palais
sabals84618862sabals
sagas66025882saga_s
saids65328852sa_ids
salaam8711012salaam
salaams997702salaams
salal55425702sala_l
salami8313102salami
salamis9313512salamis
salary9515212salary
saleps85014902saleps
sales56055592sal_es
salmis8514272salmis
salols64017872salols
salons63823692salons
salpas85116922salpas
salpids1038192salpids
salps74423242sal_ps
sals46851672sal__s
salsas65316132salsas
salts55431882sal_ts
salves94221762salves
salvos94613382salvos
sands65228582sa_nds
sarans64224432sarans
sards64736182sa_rds
sarods74918572sarods
satays94411682satays
sayeds10469252sayeds
sayids104310972sayids
scads85419962s_cads
scalade10359262scalade
scalades11258802scalades
scalado10276472scalado
scalados11276082scalados
scalars93711902scalars
scalds94813692scal_ds
selahs9313212selahs
shads95124482s_hads
sialids839722sialids
silds65520522sil_ds
skalds11437832skal_ds
slabs75322642s_labs
slags66525902s_lags
slams74927902s_lams
slaps76025712s_laps
slats55436902s_lats
slaws85222712s_laws
slays85723682s_lays
sleds64418852s_leds
solands84412342solands
solans64122492solans
solids74116402solids
splats84817302splats
splays114910872splays
squads164410292squads
stalags838642stalags
steads74116222steads
talars66021682talars
talas55935892tala_s

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit82551842.62331472.0
3Display Results84840.0165250.0
 (SQL Overall)178691842.98259923.2
 
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.