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

198 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
boater8462209(None) 
beater84729391beater
bloater94013421bloater
boaster94616431boaster
boated94221971boated
boatel84314091boatel
boaters93419231boaters
bolter83920751bolter
coater84329551coater
oater55433731_oater
abater85518122abater
aborter939922aborter
baiter84422552baiter
baker115629542b_aker
baler75635272b_aler
banter84825332banter
barer74535802b_arer
barter85525372barter
baser74828922b_aser
baster85333592baster
bate66552422b_ate_
bated85935532b_ated
bates75846342b_ates
bather115322512b_ather
batter84928872batter
beader94623792beader
beaker125520692beaker
bearer85323912bearer
beaten84617062beaten
beaters94925032beaters
beaver114819252beaver
belter84720962belter
better84723702better
bister84922762bister
biter75030032b_iter
bitter84622672bitter
blader93618582blader
blamer104417142blamer
blaster94017302blaster
blate75933782blate_
blather125314202blather
blatter94415652blatter
blazer174414022blazer
bleater94515302bleater
bloated104513432bloated
bloaters103311012bloaters
blotter94612852blotter
boar66134292boa__r
boarder103910322boarder
boasted104113742boasted
boasters103915652boasters
boat66360312boat__
boatels93510232boatels
boatmen1146912boatmen
boats75635152boat_s
bobber95016742bobber
boiler84319272boiler
boite74426322boite_
boites84322702boites
bolder94820932bolder
bolster93713422bolster
bolted94617802bolted
bolters94017802bolters
bomber125014652bomber
bonder95324782bonder
boner75133082bo_ner
bonier84321992bonier
bonzer175313672bonzer
booger94816552booger
booker124719192booker
boomer104618512boomer
booster94314552booster
booted94822732booted
bootee84323022bootee
bootery1238982bootery
boozer174815962boozer
bopper123813832bopper
borate85026152borate_
borated104116362borated
borates94823012borates
border94419972border
borer75131272bo_rer
bosker123813652bosker
botel75121862bo_tel
bother115218062bother
bottler94211882bottler
bower107328182bo_wer
bowler114217312bowler
bowyer14368922bowyer
boxer145016522bo_xer
boxier154311742boxier
bracer104620582bracer
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
broader103412602broader
bunter85020382bunter
buster84726492buster
butter84724232butter
cater74840702_cater
coaler84121702coaler
coaster94219032coaster
coated94927032coated
coatee84327212coatee
coaters93525772coaters
coaxer153912782coaxer
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
couter84930202couter
crater85026632crater
dater65332312_dater
doated84118182doated
doter65428622do_ter
dotter74419342dotter
eater54639842_eater
elater64724202elater
feater95224052feater
floater104413352floater
foamer114714312foamer
footer94320772footer
foster94322222foster
frater94520592frater
gater64533642_gater
gloater83711012gloater
goatee73219532goatee
goiter74116202goiter
grater74625432grater
hater85034752_hater
heater94828302heater
hoaxer16348562hoaxer
hooter94123922hooter
hotter94720072hotter
irater65218342irater
jolter133513092jolter
jotter134315632jotter
krater104014312krater
later54843922_later
loader74316302loader
loafer93610942loafer
loaner64416502loaner
loather103711002loather
locater93113602locater
lofter94614722lofter
loiter64619172loiter
looter64222322looter
lotter64025602lotter
mater74438862_mater
moaner84415112moaner
moated94819002moated
molter84119422molter
mooter83921092mooter
neater64424312neater
noter55025642no_ter
oaten55222402_oaten
oaters65029782_oaters
ofter84116872_ofter
otter54423972_otter
outer55633302_outer
oxter123414092_oxter
pater74740722_pater
plater84427692plater
porter84224412porter
poster84129172poster
potter83926982potter
pouter83923982pouter
powter114116032powter
prater84825352prater
rater54943282_rater
roamer84715162roamer
roarer63914332roarer
roaster74116662roaster
rooter64926032rooter
roster64329082roster
rotter64325462rotter
router65025842router
seater64534152seater
skater105015482skater
slater64429182slater
soaker105717532soaker
soaper84517872soaper
soarer64522242soarer
softer94015312softer
sorter64425082sorter
souter64225922souter
stater64427552stater
tater54138612_tater
toaster74414462toaster
tooter64420802tooter
toter55932132to_ter
totter65021462totter
touter63821032touter
voter85121052vo_ter
water84733312_water
zoster153715852zoster

Search took 4 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.1401276364.3
2DLD Change Limit825511983.75022013.6
3Display Results1981980.0633142.9
 (SQL Overall)1786911983.95345203.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.