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

153 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
bandeau103852(None) 
bandeaus1146501bandeaus
bandeaux1843291bandeaux
banda85223102band_a_
bandas95120542band_as
banded105223172bande_d
bander93928222bande_r
banders104324562banders
bandsaw1334802bandsaw
bateau8810562ba_teau
batteau936342batteau
landau7310612land_au
manteau937862manteau
rondeau846812rondeau
aboideau1142873aboideau
anear55420323_an_ear
anneal64812293_anneal
badder103817513badde_r
baddest112611143baddest
bade75140883ba_de__
badman113813843ba_dman
badness1039573badness
balded105417513balde_d
balder95318863balde_r
baldest102313533baldest
baldhead1544273baldhead
balneal936573balneal
banal75925993ban__al
banana83213413banana_
bananas93312223bananas
band76740913band___
bandage11311023bandage
bandaid11310483bandaid
bandana10179463bandana
bandanas11178573bandanas
bandbox1943763bandbox
banderol1145853banderol
bandied114414303bandied
bandies104124863bandies
banding114921413banding
bandit93821133band_it
bandito103710043bandito
bandits103814793bandits
bandmate1347973bandmate
bandog1038723band_og
bandogs1138363bandogs
bandora1038813bandora
bandoras1138743bandoras
bandore10611633bandore
bands85233423band__s
bandsaws1444623bandsaws
bandsman1346753bandsman
bandy114824183band__y
bane65250433ban_e__
baned85436353ban_e_d
baneful1237893ban_eful
banes74945583ban_e_s
banged104923723bange_d
banger94423633bange_r
bangers104020353bangers
banian8315383ban_ian
banjax2234763ban_jax
banked135021443banke_d
banker124222733banke_r
bankers133919093bankers
banned94721343banne_d
banner84421503banne_r
banners94018713banners
bannet84925333banne_t
bannets94013843bannets
bantam10314063ban_tam
banteng1046363banteng
banter84825333bante_r
banters94623113banters
banyan1139483ban_yan
banzai1737653ban_zai
barde85330773barde__
barded105426423barde_d
bardes95026933barde_s
bateaux1693883ba_teaux
batteaux1742503batteaux
beau66137273b___eau
benday123810813bend_ay
bended105521233bende_d
bendee94121023bende_e
bendees103913863bendees
bender95223303bende_r
benders104021063benders
binder94422873binde_r
binders103920743binders
bindery13459833bindery
blander103715163blande_r
blandest113811043blandest
bonded104719953bonde_d
bonder95324783bonde_r
bonders104120663bonders
bondman1238043bondman
bordeaux1843273bordeaux
branded114414103brande_d
brander103915823brande_r
branders114313093branders
bureau8712523b_ureau
candela1089743candela
candelas1139533candelas
candent10417363candent
dander811222993dande_r
danders93921183danders
endear74110013_endear
gander84322763gande_r
ganders93521703ganders
gateau778113ga_teau
handax1749583hand_ax
handbag1495863handbag
handcar1337373handcar
handed114919983hande_d
hander104526433hande_r
handers114224333handers
handsaw1435533handsaw
jambeau1843773jambeau
landaus8310343land_aus
landed84619243lande_d
lander74028483lande_r
landers84026213landers
landman1038923landman
manteaus1036383manteaus
manteaux1742883manteaux
panda85022613pand_a_
pandas95521963pand_as
pandect12310953pandect
pander93725523pande_r
panders103423733panders
randan7315253rand_an
rondeaux1642653rondeaux
sandal73317283sand_al
sandbag11106243sandbag
sandbar10108193sandbar
sanddab1144923sanddab
sanded84920613sande_d
sander74828533sande_r
sanders84025943sanders
sandman10310173sandman
tableau966283tableau
tandem9311403tande_m
tandems1037633tandems
tonneau765913tonneau
undead82711903_undead
vanda94515923vand_a_
vandal103713833vand_al
vandas103915993vand_as
wander104423713wande_r
wanders114221333wanders
zander163417113zande_r
zanders173015793zanders

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271536.31321230.3
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.76526414.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.