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

145 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
bilanders123596(None) 
bilander1136671bilander_
balancers1345062balancers
banders104324562b__anders
bilayers13296922bila_yers
binders103920742bi__nders
bladders12397802b_ladders
bladers104214682b_la_ders
blander103715162b_lander_
blenders115210992b_lenders
blinders113911142b_linders
blunders113911342b_lunders
branders114313092b_randers
colanders1238012colanders
glanders103811502_glanders
inlanders1036142inlanders
islanders1035282islanders
landers84026212__landers
malanders1237022malanders
philanders1644272philanders
slanders94014012_slanders
solanders1036962solanders
uitlanders1142832uitlanders
uplanders1234852uplanders
auslanders1143363auslanders
balancer1246603balancer_
balances1279973balance_s
bander93928223b__ander_
bangers104020353b__angers
bankers133919093b__ankers
banners94018713b__anners
banters94623113b__anters
beaders104120183b_ea_ders
belayers13298143bela_yers
benders104021063b__enders
bidders114012313bi__dders
biders94822803bi___ders
bilayer12347803bila_yer_
bilkers134711863bil__kers
billers94720833bil__lers
billeters1136873billeters
binder94422873bi__nder_
bindery13459833bi__ndery
biners85023633bi__n_ers
bingers104519993bi__ngers
biplanes1238573biplan_e_s
birders103913263bi__rders
blabbers11308153b_labbers
bladder11429153b_ladder_
bladdery15344583b_laddery
blader93618583b_la_der_
blades95221253b_la_de_s
blamers115314213b_la_mers
blanchers16307433b_lanchers
blandest113811043b_landest
blandness1235973b_landness
blanker134612023b_lanker_
blankets14356503b_lankets
blasters104116143b_lasters
blathers134713793b_lathers
blatters104414093b_latters
blazers184811683b_la_zers
bleeders11448453b_leeders
blender104613843b_lender_
blendes104713683b_lende_s
blinder103912983b_linder_
blinkers14388503b_linkers
blonder104011943b_londer_
blondes104213163b_londe_s
blunder103813153b_lunder_
blungers11469843b_lungers
boarders11408623b_oarders
bonders104120663b__onders
bounders114314113b_ounders
braiders114110573b_raiders
brander103915823b_rander_
branners104010923b_ranners
builders1146743buil__ders
byliners1334753bylin_ers
bystanders1642193bystanders
calenders1237403calenders
cinders104617763ci__nders
clangers114312343_clangers
colander1139033colander_
cylinders1543203cylinders
danders93921183__danders
demanders13247573demanders
dilaters92513063dila_ters
expanders19125093expanders
finders113717873fi__nders
flangers123311373_flangers
flankers15349303_flankers
flinders12439263_flinders
ganders93521703__ganders
gilders94212463gil__ders
glancers11408003_glancers
glandes95413833_glande_s
handers114224333__handers
highlanders1952023highlanders
hinders113718503hi__nders
inlander937223inlander_
islander946103islander_
ladders94115173__ladders
laders74927763__la_ders
lancers93616643__lancers
lander74028483__lander_
landlers94312833__landlers
lanners73618333__lanners
larders83516943__larders
lauders84012893__lauders
launders9358743__launders
lenders84419643__lenders
lowlanders1442693lowlanders
mainlanders1462503mainlanders
meanders1168833_meanders
minders103720123mi__nders
oleanders1035573oleanders
outlanders1144273outlanders
panders103423733__panders
philander1544063philander_
pilasters1138223pilasters
pilsners1035533pilsn_ers
pinders103720473pi__nders
planers94517943_plan_ers
planners10399933_planners
planters102915323_planters
plunders11329833_plunders
pomanders1436223pomanders
relaunders1153103relaunders
sanders84025943__sanders
silanes72517163silan_e_s
silencers1145283silencers
slander84015443_slander_
solander948123solander_
squanders1934443squanders
standers93514303_standers
stranders10389933stranders
tailenders1143643tailenders
tinders84219173ti__nders
uitlander1042963uitlander_
uplander1145533uplander_
wanders114221333__wanders
wilders113513503wil__ders
winders113721263wi__nders
zanders173015793__zanders

Search took 8 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.436409841.7
2DLD Change Limit1486411457.17320722.3
3Display Results1451450.0602416.7
 (SQL Overall)1786911457.66923300.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.