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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
hoaxed1737887(None) 
coaxed165612511coaxed
hoaxer16348561hoaxer
hoaxes163611691hoaxes
axed128829612__axed
boated94221972boated
boxed154318612bo_xed
coaled95022702coaled
coated94927032coated
coaxer153912782coaxer
coaxes154715632coaxes
coxed154322812co_xed
doated84118182doated
faxed166220532_faxed
foaled104515962foaled
foamed126014402foamed
foxed165115212fo_xed
goaded94913712goaded
goaled85014352goaled
haded105227622h_aded
haed86338582h_a_ed
haled95335822h_aled
hared95742182h_ared
hated95734022h_ated
hawed126025422h_awed
hayed125822012h_ayed
hazed185222202h_azed
headed114020472headed
healed105121442healed
heaped124516902heaped
heated104525592heated
heaved134717862heaved
hexed165615762h_exed
hoard94918312hoa_rd
hoarded12368342hoarded
hoax147718292hoax__
hoaxers17327132hoaxers
hobbed144114302hobbed
hoboed124511682hoboed
hocked165521302hocked
hoed87837982ho__ed
hogged125817772hogged
hoised105117432hoised
hoked135326992ho_ked
holed95634132ho_led
holked144913662holked
homaged1497412homaged
homed115425422ho_med
honed95332262ho_ned
honied104818392honied
honked144517912honked
hooded114616742hooded
hoofed134614892hoofed
hooked145320552hooked
hooped125518182hooped
hooted104422652hooted
hooved134713122hooved
hoped115628182ho_ped
hopped144318112hopped
horded115420482horded
horned105718702horned
horsed105321082horsed
hosed95830982ho_sed
hosted105020342hosted
hotbed123310672hotbed
hotted104319932hotted
housed105624102housed
howked177312342howked
howled134014962howled
loaded84616872loaded
loafed104011152loafed
loamed94414612loamed
loaned73816292loaned
loxed135017052lo_xed
maxed155821192_maxed
moaned94514172moaned
moated94819002moated
oared65030652_oared
poxed154817862po_xed
raxed135622662_raxed
roamed95215092roamed
roared75015392roared
shoaled113810962shoaled
soaked114717592soaked
soaped95817972soaped
soared74324292soared
taxed135620292_taxed
unaxed144113092unaxed
waxed166018482_waxed
woaded115211602woaded

Search took 6 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.1101624463.6
2DLD Change Limit82551905.37315364.0
3Display Results90900.0461956.5
 (SQL Overall)178691905.52932318.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.