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

174 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
elater6472420(None) 
eater54639841e_ater
elate55335881elate_
elated74725821elated
elaters74420181elaters
elates65032361elates
later54843921_later
plater84427691plater
relater73723141relater
slater64429181slater
abater85518122abater
alate55340322alate_
alated75625142alated
alates64833962alates
alter54828502al_ter
beater84729392beater
belated103520012belated
belayer12339502belayer
belter84720962bel_ter
blader93618582blader
blamer104417142blamer
blaster94017302blaster
blate75933782blate_
blather125314202blather
blatter94415652blatter
blazer174414022blazer
bleater94515302bleater
bloater94013422bloater
boater84622092boater
cater74840702_cater
clatter94014972clatter
claver113816972claver
clawer114512782clawer
coater84329552coater
crater85026632crater
dater65332312_dater
debater104114692debater
deflater123211602deflater
delate73827752delate_
delated93722872delated
delates83526282delates
delator83015022delator
delayer113010532delayer
dewater112912422dewater
dilater83515642dilater
eager65526962e_ager
easter65027982easter
eaten55323052e_aten
eaters65535942e_aters
eatery95316352e_atery
eglatere945142eglatere
elaterid948612elaterid
elaterin849902elaterin
elder64020022el_der
elite56230182elite_
elites66027122elites
elmier839812elmier
eloper85414152eloper
eluate62315432eluate_
eluates72014672eluates
eluder73712212eluder
elute54822572elute_
eluted74915262eluted
elutes64020312elutes
elver85216242el_ver
emoter85415192emoter
enate54428142enate_
enates64026422enates
enter54726382e_nter
eraser64216332eraser
ester54727712e_ster
evader1036812evader
exacter1637402exacter
exalter1437562exalter
falter94519052falter
feater95224052feater
flaker134916172flaker
flamer114919122flamer
flatter103815962flatter
flayer124713562flayer
floater104413352floater
fluter95316862fluter
frater94520592frater
gater64533642_gater
gelate73421252gelate_
gelated93615632gelated
gelates83219582gelates
glazer164212262glazer
gloater83711012gloater
grater74625432grater
halter94420882halter
hater85034752_hater
heater94828302heater
irater65218342irater
kelter103214372kel_ter
krater104014312krater
lacer75833752_lacer
lader65633722_lader
lager65132862_lager
laker95432872_laker
lamer75233702_lamer
laser54633322_laser
laster64830632_laster
late47560482_late_
lated65240672_lated
laten54328342_laten
latex124717112_latex
lather95124352_lather
latter65027892_latter
laver85031792_laver
laxer125420332_laxer
layer84626472_layer
leader74824652leader
leaker104620072leaker
leaner64022192leaner
leaper88118942leaper
leaser65322672leaser
leather103815782leather
leaver94321512leaver
lefter93613432lefter
letter63722582letter
liter54736342_liter
mater74438862_mater
melter83520112mel_ter
neater64424312neater
negater83711952negater
oater55433732_oater
palter84423262palter
pater74740722_pater
pelter83321622pel_ter
placer105117742placer
plaiter93615392plaiter
planer84122652planer
planter94017802planter
plaster93318692plaster
plate74635112plate_
plated95225772plated
platen84518202platen
platers93924082platers
plates85432242plates
platier93716292platier
platter93917412platter
player115215212player
pleater93916332pleater
prater84825352prater
rater54943282_rater
realter73716312realter
rebater93517902rebater
relate64033632relate_
related83327572related
relaters83218142relaters
relates73731422relates
relator74016362relator
relaxer143410222relaxer
salter64325082salter
seater64534152seater
sedater83713622sedater
skater105015482skater
slaker104219272slaker
slate55438282slate_
slated75028312slated
slaters73123722slaters
slates64934062slates
slatey95417062slatey
slather103816062slather
slatier74016812slatier
slaver94419612slaver
slayer93916332slayer
stater64427552stater
tater54138612_tater
ulster63712102ulster
velate93720142velate_
water84733312_water
welter93417382wel_ter

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 Filter178691825510.216827273.1
2DLD Change Limit825511745.90613977.5
3Display Results1741740.1101581.8
 (SQL Overall)1786911746.23228673.1
 
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.