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 “border” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

156 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
border9441997(None) 
birder94915491birder
boarder103910321boarder
bolder94820931bolder
bonder95324781bonder
bordel94514571bordel
borders104317531borders
borer75131271bor_er
corder94322881corder
order65019361_order
aborter939932aborter
badder103817512badder
balder95318862balder
bander93928222bander
barber104419322barber
barde85330772barde_
barded105426422barded
bardes95026932bardes
barer74535802bar_er
barker124822862barker
barter85525372barter
beader94623792beader
bedder104215792bedder
bender95223302bender
bidder104114862bidder
bider85728372b_ider
binder94422872binder
birded104414302birded
birders103913262birders
birler85715082birler
blader93618582blader
blonder104011942blonder
boarded113910502boarded
boarders11408622boarders
boater84622092boater
bobber95016742bobber
bode75838752bo_de_
boded95124962bo_ded
bodes84935102bo_des
boiler84319272boiler
bolter83920752bolter
bomber125014652bomber
bonded104719952bonded
bonders104120662bonders
boner75133082bo_ner
bonier84321992bonier
bonzer175313672bonzer
boodler103312002boodler
booger94816552booger
booker124719192booker
boomer104618512boomer
boozer174815962boozer
bopper123813832bopper
bordels103911972bordels
bordered1248932bordered
borderer1168102borderer
bordure1035782bordure
bore66051332bor_e_
bored85034302bor_ed
boreen8314312boreen
borers85122682bor_ers
bores76448252bor_es
boride9415902boride_
borides10515152borides
borked135117292borked
borne77926792borne_
bosker123813652bosker
bother115218062bother
boulder103411342boulder
bounder104215532bounder
bower107328182bo_wer
bowlder13407482bowlder
bowler114217312bowler
bowyer14368922bowyer
boxer145016522bo_xer
boxier154311742boxier
brier74527402b_rier
broader103412612broader
broider103912972broider
broker124314242broker
brooder103811622brooder
budder104314812budder
burden9412472burden
burger94020792burger
burier84324652burier
burker125221172burker
burler84723832burler
burner83819202burner
burrer83718472burrer
carder94524182carder
codder104416342codder
coder86134222co_der
colder95121852colder
corded105923352corded
corders104520882corders
corer75538872cor_er
corker124720852corker
corner84625622corner
dodder94712912dodder
dormer94415902dormer
dorper94314572dorper
dorser74819182dorser
emborder1345082emborder
fodder114712112fodder
folder104317542folder
fonder104120062fonder
forcer114917342forcer
forded115020392forded
forger104820772forger
forker134717902forker
former114221402former
girder84312062girder
golder84417602golder
gorger86116982gorger
gorier73719372gorier
harder105022402harder
herder104516462herder
hoarder11329232hoarder
holder104619652holder
horde94623052horde_
horded115420482horded
hordes104921632hordes
larder73720972larder
loader74316312loader
lorded84916732lorded
louder74414602louder
molder93819272molder
murder93613782murder
nodder84811942nodder
odder74515392_odder
older65121172_older
orders74315992_orders
ormer75218372_ormer
polder94019252polder
ponder94521692ponder
porker124917542porker
porter84224412porter
powder123611902powder
reorder8239482reorder
solder73921342solder
sonder73623522sonder
sordor7310222sordor
sorer56236592sor_er
sorner64720392sorner
sorter64425092sorter
suborder1146662suborder
voider103611552voider
warder104020272warder
wonder103617812wonder
worded114316622worded
wordier112511212wordier
worker134715112worker
wormer114514912wormer
worser95117522worser
yarder103813972yarder
yonder103214132yonder

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825511562.22037185.1
3Display Results1561560.0602600.0
 (SQL Overall)1786911562.60668569.1
 
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.