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

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

65 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
hooraying164478(None) 
hoorahing1644911hoorahing
foraying1537432_foraying
hurraying1654322hurraying
affraying1943103affraying
arraying1238753_arraying
betraying1537713betraying
bewraying1834873bewraying
boogeying1643623boogeying
boogying1535373boo_gying
borating113414503_borating
braying134416313__braying
cooeying1438143coo_eying
corrading1338203corrading
covarying1844133covarying
defraying1735853defraying
doomsaying1751503doomsaying
draying123813843__draying
estraying1338293estraying
foraging1358063_foraging
fraying143413433__fraying
glorying1335543glor_ying
graying124115883__graying
harrying15157643h_arrying
haying134420613h___aying
herrying15147023h_errying
hoarding13288643hoar_ding
hoaxing18307763h_o_axing
hogtying1633553h_ogtying
holidaying1842393holidaying
hollaing12167093holla_ing
homaging1536613h_omaging
honeying1537673h_oneying
honoring12310473honor__ing
hooding123815203hoo__ding
hoodooing14103933hoodooing
hoofing143912553hoo__fing
hooking153716693hoo__king
hooping133615703hoo__ping
hooray123011373hooray___
hoorayed1544013hooray_ed
hoorays13418373hooray__s
hooting113919883hoo__ting
hoovering1635753hoovering
hording123517053h_or_ding
horning113015003h_or_ning
horrifying2043983horrifying
horsing113215583h_or_sing
hoseying1537193h_oseying
howdying1933713h_owdying
hurrahing1643753hurrahing
hurrying15145533h_urrying
hydrating1746323hydrating
mooring102514443moor__ing
nonpaying1545713nonpaying
okaying1534833__okaying
orating83520323__orating
portraying1645163portraying
praying133717323__praying
prorating12314283prorating
raying105027193___raying
spraying14299883_spraying
storying12249673stor_ying
straying122912693_straying
worrying1534703_worrying

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641657.47019898.4
3Display Results65650.0302166.7
 (SQL Overall)178691657.92322553.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.