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

179 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
bilander113667(None) 
bilanders1235961bilanders
blander103715171b_lander
balancer1246602balancer
bander93928222b__ander
bilayer12347802bila_yer
binder94422872bi__nder
bladder11429152b_ladder
blader93618582b_la_der
blanker134612022b_lanker
blender104613852b_lender
blinder103912992b_linder
blonder104011952b_londer
blunder103813162b_lunder
brander103915822b_rander
colander1139032colander
inlander937222inlander
islander946102islander
lander74028492__lander
philander1544062philander
slander84015452_slander
solander948122solander
uitlander1042962uitlander
uplander1145542uplander
auslander1043883auslander
badder103817513b__adder
balance11510263balance_
balanced1356513balanced
balancers1345063balancers
balances1279973balances
balder95318863b__alder
banded105223173b__anded
banders104324563b__anders
banger94423643b__anger
banker124222733b__anker
banner84421503b__anner
banter84825343b__anter
beader94623793b_ea_der
belauded1244793belauded
belayer12339503bela_yer
bender95223303b__ender
bidder104114863bi__dder
bider85728383bi___der
bilayers13296923bila_yers
bilgier10358533bil_gier
bilinear1044043bilinear
bilker124913443bil__ker
biller84923483bil__ler
billeter1037563billeter
binders103920743bi__nders
bindery13459833bi__ndery
biner75930693bi__n_er
binger94923453bi__nger
biplane1139033biplan_e_
biplanes1238573biplan_es
birder94915493bi__rder
blabber10418923b_labber
blacker154513513b_lacker
bladders12397803b_ladders
bladdery15344583b_laddery
blade85923333b_la_de_
bladed104717763b_la_ded
bladers104214683b_la_ders
blades95221253b_la_des
blamer104417143b_la_mer
blancher15338633b_lancher
bland85320453b_land__
blandest113811043b_landest
blandly1336043b_landly
blanked144011223b_lanked
blanket134313093b_lanket
blaster94017303b_laster
blather125314213b_lather
blatter94415653b_latter
blazer174414023b_la_zer
bleeder10359643b_leeder
blende95413443b_lende_
blended114710713b_lended
blenders115211003b_lenders
blendes104713683b_lendes
blinded114810023b_linded
blinders113911153b_linders
blinker134110213b_linker
blonde94813293b_londe_
blondes104213163b_londes
blunders113911353b_lunders
blunger104112023b_lunger
blunter94512043b_lunter
boarder103910323b_oarder
bolder94820933bol__der
bonder95324783b__onder
bounder104215543b_ounder
braider105112993b_raider
branded114414103b_randed
branders114313093b_randers
branner94212373b_ranner
broader103412613broa_der
builder1037573buil__der
byliner1235723bylin_er
bystander1542593bystander
calender1138273calender
cinder94119123ci__nder
clanger104113493_clanger
colanders1238013colanders
cylinder1433383cylinder
dander811222993__dander
demander12238723demander
dilater83515653dila_ter
expander18145803expander
finder104020233fi__nder
flanger113412623_flanger
flanker143911293_flanker
flinder11319883_flinder
gander84322763__gander
gilder84415533gil__der
gladder10398313_gladder
glancer103710073_glancer
glanders103811513_glanders
glandes95413833_glandes
grander93315873_grander
hander104526433__hander
highlander1852563highlander
hinder104120063hi__nder
inaner62213543_inan_er
inlanders1036143inlanders
islanded1035513islanded
islanders1035283islanders
kinder113716853ki__nder
ladder84617623__ladder
lader65633723__la_der
lancer84319973__lancer
landed84619243__landed
landers84026223__landers
landler84113203__landler
lanker104123003__lanker
lanner64920603__lanner
larder73720973__larder
lauder73815013__lauder
launder8309153__launder
lender73921283__lender
lowlander1342993lowlander
mainlander1352973mainlander
malanders1237023malanders
meander1049973_meander
milder93818453mil__der
minder94822503mi__nder
oleander936403oleander
outlander1045733outlander
pander93725533__pander
philanders1644273philanders
pilaster1038163pilaster
pilsner935343pilsn_er
pinder94523463pi__nder
planer84122663_plan_er
planner93511633_planner
planter94017813_planter
plunder103810513_plunder
pomander1347083pomander
relanded102410463relanded
relaunder1053703relaunder
sander74828533__sander
silane62718053silan_e_
silanes72517163silan_es
silencer1036303silencer
silenter838873silenter
slanders94014023_slanders
slender83413603_slender
solanders1036963solanders
squander1835533squander
stander84316163_stander
strander97112063strander
tailender1044073tailender
tinder73821803ti__nder
uitlanders1142833uitlanders
uplanders1234863uplanders
wander104423713__wander
wilder103616473wil__der
winder104025263wi__nder
zander163417113__zander

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.470380193.6
2DLD Change Limit1461621797.81318707.5
3Display Results1791790.0632841.3
 (SQL Overall)1786911798.34621410.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.