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

59 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
saladang104384(None) 
saladangs1142911saladangs
seladang1043401seladang
seladangs1142382seladangs
alang66023513_al__ang
balding114015063bal_ding
blading113615363_blading
escalading1443573escalading
galavant1246353galavant
lading84227123__lading
paladin101011773paladin_
paladins11911003paladins
parading12313863parading
parasang1147333parasang
sagaman10117563sagaman_
salaam8711013sala_a_m
salaaming1265363salaaming
salaams997703sala_ams
salad65321833salad___
salads75316963salad__s
salarying1336073salarying
sallying12309853sallying
salpian938493salpian_
salpians1036763salpians
saltant7316773sal_tant
salting84120793sal_ting
saltpan935303saltpan_
saltpans1034813saltpans
saluting9310553saluting
salvaging1465283salvaging
salving113913153sal_ving
salvoing1236423salvoing
sanding93520603sa_nding
saraband1146193saraband
sardana838643sa_rdana
satang75711563s__atang
savaging1356673savaging
scalawag14142773scalawa_g
scalding12339393scal_ding
shading123115563s_hading
sialidan943823sialidan_
sialidans1042973sialidans
siamang1045333s_iamang
slaking123717473s_laking
slang66324023s_l__ang
slating83724653s_lating
slaving113514833s_laving
slaying113316843s_laying
sliding93114553s_liding
solacing11310133solacing
solating9315593solating
soldan73511853sol_dan_
soldans83210403sol_dans
spading113114383s_pading
splaying14219303splaying
steading103613593steading
suldan72611043sul_dan_
suldans8299723sul_dans
unlading1058863unlading

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 Filter1786911461620.436409841.7
2DLD Change Limit146162597.84618628.9
3Display Results59590.0134538.5
 (SQL Overall)178691598.29521542.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.