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

97 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
bandeaus114650(None) 
bandeau1038521bandeau_
bandeaux1843291bandeaux
bandas95120542band_a_s
banders104324562bande_rs
bandsaws1444622bandsaws
landaus8310342land_aus
manteaus1036382manteaus
aboideaus1251773aboideaus
anears63717183_an_ears
angelus8418463_angelus
anneals7449943_anneals
badass949293ba_d_ass
badness1039573badne_ss
baldheads1644133baldheads
bananas93312223banana_s
banda85223103band_a__
bandage11311023band_age
bandages12310633bandages
bandaid11310483band_aid
bandana10179463band_ana
bandanas11178573bandanas
banded105223173bande__d
bander93928223bande__r
banderol1145853banderol
banderols1245953banderols
bandies104124863band_ies
banditos11347633banditos
bandits103814793band_its
bandmate1347973bandmate
bandmates1447923bandmates
bandogs1138363band_ogs
bandoras1138743bandoras
bandores11311603bandores
bands85233423band___s
bandsaw1334803bandsa_w
baneful1237893ban_eful
banes74945583ban_e__s
bangers104020353bange_rs
banians9312033ban_ians
bankers133919093banke_rs
banners94018713banne_rs
bannets94013843banne_ts
bantams1149063ban_tams
bantengs1134593bantengs
banters94623113bante_rs
banyans1237913ban_yans
banzais1837163ban_zais
bardes95026933barde__s
bateau8810563ba_teau_
bateaux1693883ba_teaux
batteau936343batteau_
batteaux1742503batteaux
beaus75127113b___eaus
bendays13327513bend_ays
bendees103913863bende_es
benders104021063bende_rs
bendways1743733bendways
binders103920743binde_rs
bonders104120663bonde_rs
bordeaux1843273bordeaux
branders114313093brande_rs
bureaus979293b_ureaus
candelas1139533candelas
danders93921183dande_rs
endears83710053_endears
ganders93521703gande_rs
gateaus866333ga_teaus
handbags15116363handbags
handcars1437623handcars
handers114224333hande_rs
handsaws1545873handsaws
landau7310613land_au_
landers84026213lande_rs
landmass1144423landmass
mandamus1345523mandamus
manteau937863manteau_
manteaux1742883manteaux
pandanus1136433pandanus
pandas95521963pand_a_s
pandects1335843pandects
panders103423733pande_rs
randans8313213rand_ans
rondeau846813rondeau_
rondeaux1642653rondeaux
sandals82715203sand_als
sandbags1296373sandbags
sandbars11108783sandbars
sanddabs1243903sanddabs
sanders84025943sande_rs
tableaus1054853tableaus
tandems1037633tande_ms
tonneaus853913tonneaus
vandals113211663vand_als
vandas103915993vand_a_s
wanders114221333wande_rs
zanders173015793zande_rs

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.403443402.0
2DLD Change Limit146162977.86018595.7
3Display Results97970.0501940.0
 (SQL Overall)178691978.31321495.4
 
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.