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

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

102 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
pandanus113643(None) 
bandanas11178572bandanas
landaus8310342landa_us
mandamus1345522mandamus
pandani1039902pandan_i
pandanuses1343362pandanuses
pandas95521962panda__s
pendants1139092pendants
randans8313212randan_s
andante8311273_andante
andantes9310853_andantes
bananas93312223ban_anas
bandages12310633bandages
bandana10179463bandan_a
bandanna11174073bandanna
bandannas12163283bandannas
bandas95120543banda__s
bandeaus1146503bandeaus
banians9312033banian_s
banyans1237913banyan_s
cancans11311873cancan_s
fandango1342993fandango
fandangos1442293fandangos
fondants1246203fondants
handaxes1938403handaxes
handguns1344363handguns
kanbans1337723kanban_s
labdanum1342923labdanum
labdanums1452153labdanums
ladanum1045183la_danum
ladanums1143603la_danums
landau7310613landa_u_
landings103110073landings
lantanas838263lantanas
laudanum1143143laudanum
laudanums1242183laudanums
lindanes939173lindanes
mananas93414733man_anas
mandalas1139443mandalas
mandates11314093mandates
manganous1245763manganous
mannans93611523mannan_s
nandinas936573nandinas
nandins8312003nandin_s
padauk1335643pa_da_uk
padauks1443943pa_dauks
paddings13297013paddings
padnags1135083padna_gs
paeans85118263pa_ean_s
paesanos10296703paesanos
paesans93312693paesan_s
pagans95717923pa_gan_s
pageants1136693pageants
paisanas10288873paisanas
paisanos10337553paisanos
paisans93614753paisan_s
panadas103312213pan_adas
panamas113112763pan_amas
pancakes1637073pancakes
panda85022613panda___
pandects1335843pandects
panders103423733pand_ers
pandies104224503pand_ies
pandits103914213pand_its
pandoors11258983pandoors
pandoras11310053pandoras
pandores11312453pandores
pandour10408213pand_our
pandours11317993pandours
panduras1136953panduras
pangas99921103panga__s
pangenes112612823pangenes
pangens103112063pangen_s
pannes85522853pan__nes
parangs104314373pa_rangs
pardahs13289673parda_hs
pardons103817623pardon_s
parians93519733parian_s
partans94418283partan_s
parvenus1335653parvenus
pavanes123612653pa_vanes
pavans115715593pa_van_s
paydays1634433payda_ys
pedants10310113p_edants
penangs10268373pen_angs
pendant10314853pendan_t
pendents1139413pendents
pennants1037063pennants
pentanes10316083pentanes
pinangs10267793pin_angs
pintanos10107553pintanos
quandangs2042253quandangs
randan7315253randan__
sandals82715203sanda_ls
sandbanks1644213sandbanks
sardanas937813sardanas
tantalus836373tantalus
vanadous1246033vanadous
vandals113211663vanda_ls
vandas103915993vanda__s
wangans1149503wangan_s
zananas16319563zan_anas

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 Limit1461621027.51619446.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.98222386.7
 
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.