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

94 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
hayey14481253(None) 
hayed125822011hayed
hayer114620241hayer
aye67151762_aye_
ayes76543512_ayes
bayed115423022bayed
cagey115917822cagey
cakey145517272cakey
clayey14407662clayey
fakey155515422fakey
fayed126422152fayed
gamey115320552gamey
gayer94519192gayer
gayety13116382gayety
gayly124513092gayly
hacek145411842hacek
hade85440192hade_
haded105227622haded
hades96035112hades
hae67364002ha_e_
haed86338582ha_ed
haem95730982ha_em
haen76229452ha_en
haes77651022ha_es
haet75659502ha_et
hairy115316832hairy
hajes155420942hajes
hake115637842hake_
hakes126034302hakes
hale76052832hale_
haled95335822haled
haler85033522haler
hales85449842hales
hame97043132hame_
hames106138702hames
hammy155113432hammy
handy125520872handy
hanky155418292hanky
haply135915062haply
happy155813532happy
hardy125622062hardy
hare76255732hare_
hared95742182hared
harem104924452harem
hares86255542hares
harpy136418202harpy
harry115322952harry
hasty115718762hasty
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
have106137072have_
haven114718532haven
haver115124462haver
haves116034872haves
hawed126025422hawed
hawkey19507632hawkey
hay97358772ha__y
hayers124415942hayers
hays106138072hay_s
haze164833392haze_
hazed185222202hazed
hazel176414812hazel
hazer174820232hazer
hazes174928322hazes
hazy1918119192ha_zy
hey96741062h__ey
heydey1634632heydey
hokey155422182hokey
holey115626902holey
homey135924842homey
honey115629912honey
hooey114926602hooey
hosey116127022hosey
lacey105820912lacey
layed95127382layed
layer84626472layer
mamey125418832mamey
matey107022662matey
mayed115522402mayed
pacey126720282pacey
payed115925932payed
payee105524722payee
payer105125722payer
rayed95127502rayed
sayed96127142sayed
sayer84926552sayer
shaley123714992shaley
skyey15537222skyey
waney115120322waney
wavey145115542wavey
wheyey1834322wheyey
yawey14458272yawey

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800941.79629955.5
3Display Results94940.0165875.0
 (SQL Overall)178691941.90593801.0
 
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.