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

71 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
gunshot115665(None) 
gunshots1244371gunshots
gumshoe1343662gumshoe
gunship1345382gunship
outshot10312102outshot
sunspot947162sunspot
unshod1067602_unshod
unshut939012_unshut
upshot1138452_upshot
airshot1059493airshot
bowshot1578253bowshot
buckshot1954963buckshot
bullshot1345053bullshot
cushat113513693cu_shat
earshot10410823earshot
eyeshot1386553eyeshot
fusspot1244073fusspot
guest65225923gues__t
gumboot1246493gumboot
gumshoed1542703gumshoed
gumshoes1444123gumshoes
gunboat1047363gunboat
gundog935793gun_dog
gunkhole1693253gunkhole
gunroom1045053gunroom
guns55533483guns___
gunsel7339853guns_el
gunsels8338133gunsels
gunships1445173gunships
gunsmith1442763gunsmith
gunstock1543463gunstock
gursh94512333gursh__
gurshes112210033gurshes
gush85424003gu_sh__
gushed114816243gu_shed
gusher104115773gu_sher
gushes104719033gu_shes
gushy125213123gu_sh_y
gusset7316433gu_sset
gust55240703gu_s__t
gusto65414643gu_sto_
guyot9314523gu__yot
hipshot15106643hipshot
hotshot1358343hotshot
manihot121112053manihot
moonshot1346283moonshot
outshoot1149163outshoot
outshout1149493outshout
potshot1249733potshot
reshot93519633_reshot
rimshot1246213rimshot
shot76150263___shot
slungshot1352043slungshot
sunset63723633suns_et
sunspots1045083sunspots
sunsuit748693sunsuit
ungot61718063_un_got
unhat81119263_un_hat
unknot1037413_unknot
unroot6315553_unroot
unseat64221023_unseat
unsent63820963_unsent
unset54532433_uns_et
unshed10313773_unshed
unshift1387423_unshift
unship1148033_unship
unshorn1036943_unshorn
unshowy1644173_unshowy
unstop837473_unstop
upshoot1256693_upshoot
upshots1235193_upshots

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027716.45320769.7
3Display Results71710.0332151.5
 (SQL Overall)178691716.89225927.3
 
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.