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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
salals6512008(None) 
halals95018311halals
sabals84618861sabals
salads75316961salads
salal55425701salal_
salols64017871salols
aals49941142_a_als
alans55636172_alans
alas46358122_ala_s
alls46740922_al_ls
baals76122702ba_als
balas76937212bala_s
balls76236412bal_ls
cabals104020152cabals
callas84526752callas
calls75634732cal_ls
canals84421662canals
fallals103310192fallals
falls85727652fal_ls
galahs105512672galahs
galas65731642gala_s
galls64729322gal_ls
gayals1039512gayals
halal85623592halal_
halala94715092halala
halalas104214082halalas
halls85633782hal_ls
hamals114816822hamals
jacals1539872jacals
jalaps15299182jalaps
kalams12310602kalams
lalls55324132lal_ls
malars85020682malars
malls76233432mal_ls
nalas55528362nala_s
nasals63312462nasals
palais8420422palais
palls74332562pal_ls
ratals64219582ratals
sabal75422482sabal_
sacrals93311792sacrals
sagas66025882saga_s
sails55738102sa_ils
salaam8711012salaam
salaams997702salaams
salable91415462salable
salably121610742salably
salad65321832sala_d
salami8313102salami
salamis9313512salamis
salary9515212salary
saleps85014902saleps
sales56055592sal_es
sall44544682sal_l_
sally85129712sal_ly
salmis8514272salmis
salol55222142salol_
salons63823692salons
salpas85116922salpas
salps74423242sal_ps
sals46851672s__als
salsas65316132salsas
salts55431882sal_ts
salves94221762salves
salvos94613382salvos
sambals115213482sambals
sandals82715202sandals
sarans64224432sarans
satays94411682satays
sauls55128122sa_uls
scalars93711902scalars
scalls84218202scal_ls
seals54839692s_eals
selahs9313212selahs
sells55134432sel_ls
sepals85217372sepals
sheals94420642sheals
shoals94215792shoals
sials54227242s_ials
sills55135992sil_ls
sisals63013572sisals
skoals10438242skoals
slabs75322642s_labs
slags66525902s_lags
slams74927902s_lams
slaps76025712s_laps
slats55436902s_lats
slaws85222712s_laws
slays85723682s_lays
smalls84514122smal_ls
solans64122492solans
spalls84217342spal_ls
splats84817302splats
splays114910872splays
stalags838642stalags
stalls64019932stal_ls
steals64020062steals
talars66021682talars
talas55935892tala_s
talls55133432tal_ls
tamals84116632tamals
wallas95719392wallas
walls85529382wal_ls

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 Limit825511032.62331472.0
3Display Results1031030.0333121.2
 (SQL Overall)1786911032.99959583.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.