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 “banderols” 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
banderols124595(None) 
banderol1145851banderol_
banderole1245141banderole
banderoles1344851banderoles
bannerols1144091bannerols
banders104324562bander__s
bannerol1044312bannerol_
falderols13103882falderols
wanderoos1345552wanderoos
andirons948423_andirons
andros7313303_and_ro_s
anserous8410543_anserous
bandeaus1146503bande_aus
bander93928223bander___
banderilla1352623banderilla
banderillas1452213banderillas
banditos11347633bandito_s
bandogs1138363band__ogs
bandoras1138743bandor_as
bandores11311603bandor_es
bangers104020353banger__s
bankerly1744333banker_ly
bankers133919093banker__s
bankroll1443493ban_kroll
bankrolls1543003ban_krolls
bannerets11205463bannerets
banners94018713banner__s
banterers112410003banterers
banters94623113banter__s
baudrons1135763baud_rons
benders104021063bender__s
binderies12311683binderies
binders103920743binder__s
bonders104120663bonder__s
branders114313093brander__s
cancerous1367533cancerous
cankerous1566053cankerous
cinderous1247043cinderous
danders93921183dander__s
dangerous1146103dangerous
falderals13104043falderals
falderol12103853falderol_
folderols13103663folderols
ganders93521703gander__s
handers114224333hander__s
landers84026213lander__s
mandrels1137313mand_rels
mandrils1138493mand_rils
nerols6914883__n_erols
panderers12229153panderers
panders103423733pander__s
ponderous1267273ponderous
sanders84025943sander__s
santeros8311193santero_s
slanderous1144893slanderous
wanderers13228483wanderers
wanderoo1245663wandero_o
wanders114221333wander__s
zanders173015793zander__s

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit148641596.50022867.8
3Display Results59590.0331787.9
 (SQL Overall)178691596.95325699.8
 
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.