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

76 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
hayracks204531(None) 
hatracks1737531hatracks
hayrack1945541hayrack_
hayricks2043761hayricks
arracks1387732_arracks
barracks1636882barracks
caracks152211562ca_racks
carracks1637712carracks
hatrack1638212hatrack_
haycocks2244112haycocks
hayrick1944182hayrick_
haystacks2143372haystacks
hyraces1537912h_yraces
paybacks2145492paybacks
amtracks1696633amtracks
araks94820883_a_ra_ks
arrack121110253_arrack_
attacks13126943_attacks
barrack1538253barrack_
buybacks2144783buybacks
calpacks18266523calpacks
caprocks1835943caprocks
carack142113173ca_rack_
carjacks2345573carjacks
carrack1548753carrack_
coatracks1745403coatracks
cracks144817003__cracks
fatbacks1946003fatbacks
graybacks2143823graybacks
hacks144928713h___acks
haddocks1984903haddocks
haircaps15144363haircaps
hairlocks1863773hairlocks
halfbacks2343993halfbacks
halftracks22102103halftracks
hammocks2164343hammocks
harass9313943ha_ra_ss
hardbacks2145373hardbacks
hardhacks2243703hardhacks
hardpacks2143623hardpacks
hardtacks1943803hardtacks
harks126333433ha_r__ks
hassocks1744693hassocks
haversacks2252203haversacks
haycock2144313haycock_
hayforks2143423hayforks
haylages1536013haylages
hayrides1536883hayrides
haystack2044013haystack_
haywards1845873haywards
headraces1546613headraces
hijacks2333533h_ijacks
hogbacks2044853hogbacks
hopsacks1944733hopsacks
hyraxes2045703h_yraxes
jaywalks2542143jaywalks
kayaks1236333kay_a_ks
kyacks14416063_ky_acks
lavrocks1743663lavrocks
maracas11313773ma_racas
payback2056453payback_
playbacks2244133playbacks
racks115028853___racks
ransacks1445773ransacks
reracks132310533_reracks
retracks14149103retracks
shadrachs1843303shadrachs
shamrocks2043033shamrocks
skyjacks2342543skyjacks
swaybacks2343583swaybacks
tamaracks1743753tamaracks
tracks124818843__tracks
untracks1437523untracks
whitracks2142943whitracks
wracks154711113__wracks
yacks144419813__y_acks

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit146162768.87316472.7
3Display Results76760.0332303.0
 (SQL Overall)178691769.06219718.7
 
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.