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 “haply” 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
haply13591506(None) 
happy155813531happy
hiply134113611hiply
ably99725132_ably
agly86821802_agly
ally76935642_ally
amply125012912amply
apply125111392apply
aptly105111812_aptly
badly114918762badly
bally105530102bally
chally144314292chally
cheaply1735022cheaply
daily95922332daily
dally95324742dally
damply14337892damply
early85324122early
fatly115716802fatly
gaily95020972gaily
gally95026172gally
gappy136212032gappy
gapy106320912gap_y
gayly124513092gayly
hackly18298732hackly
hail74839062hail_
hails85231642hails
hairy115316832hairy
hale76052832ha_le
half106238452ha_lf
hall75741162ha_ll
hallo85127552hallo
halls85633782halls
halm95834972ha_lm
halo76437322ha_lo
halt76056302ha_lt
hammy155113432hammy
handy125520872handy
hanky155418292hanky
haole84820082haole
hap87360052hap__
hapax1739322hapax
happily1745762happily
haps96443462hap_s
hardly135112832hardly
hardy125622062hardy
harl75740002harl_
harls85634502harls
harpy136418202harpy
harry115322952harry
hasty115718762hasty
haul75530452haul_
haulm104415412haulm
haulmy14455552haulmy
hauls86123732hauls
hay97358772ha__y
hayey144812532hayey
hazily2179062hazily
hazy1918119192ha_zy
heapy135914982heap_y
hilly114422162hilly
hippy155112792hippy
holly114824432holly
holy106333432h_oly
hooly115022222hooly
hoppy154912352hoppy
hotly115815472hotly
hurly115819292hurly
imply124911842imply
laxly15610102laxly
madly115218132madly
manly105022942manly
maple95521142maple
marly106925612marly
nappy126312332nappy
pally105727122pally
paly95835532pa_ly
pappy114713802pappy
patly105020582patly
ply86323552__ply
rally84725902rally
raptly11338912raptly
rawly115115832rawly
reply104015852reply
sadly94519122sadly
sally85129712sally
sappy125413472sappy
shaly114322862sha_ly
shapely1536892shapely
sharply15406832sharply
tally84526862tally
wally114625092wally
waly105830902wa_ly
wanly115118022wanly
zappy21548942zappy

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 Filter178691538000.0931921408.6
2DLD Change Limit53800941.89028465.6
3Display Results94940.0332848.5
 (SQL Overall)178691942.01688636.4
 
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.