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

66 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
gunboat104736(None) 
gunboats1144821gunboats
bumboat1349022bumboat
gumboot1246492gumboot
tugboat10126102tugboat
unbolt83013892_unbolt
airboat9512133airboat
boat66360313___boat
bumboats1445183bumboats
burbot10815653burbo_t
catboat11412243catboat
flyboat1546003flyboat
genoa64315823gen_oa_
genoas74013623gen_oas
gloat65427683g__loat
gnat56034433g_n__at
goat56250833g___oat
groat65531973g__roat
gumbo104413583gumbo__
gumboil1244373gumboil
gumboots1344253gumboots
gumbos114610873gumbo_s
gundog935793gundo_g
gundogs1034603gundogs
gunlock1444563gunlock
gunman9299453gun_man
gunplay1343233gunplay
gunpoint1146673gunpoint
gunroom1045053gunroom
gunshot1156653gunshot
guyot9314523gu_yo_t
iceboat1147163iceboat
johnboat2053373johnboat
longboat1146093longboat
numbat10312083numb_at
outboast1048543outboast
pigboat1247823pigboat
rowboat1267983rowboat
rubout8313563ru_bout
runabout1045853runabout
runout6414873run_out
sunbath1236423sunb_ath
sunbeam1146053sunbeam
sunbelt939233sunbelt
sunbow1145823sunbo_w
sunbows1236023sunbows
surcoat9412923surcoat
surfboat1345333surfboat
towboat1258303towboat
tugboats11154103tugboats
turbot8914263turbo_t
turncoat1044853turncoat
unban72114333_unb_an
unbar71913613_unb_ar
unbear889163_unbear
unbelt83015693_unbelt
unbent83216593_unbent
unbolts9247803_unbolts
unborn83310813_unborn
unbox1438753_unbo_x
ungot61718063_ungo_t
unhat81119263_un_hat
unload73010803_unload
unroot6315553_unroot
unseat64221023_unseat
upbeat10911513_upbeat

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.403443402.0
2DLD Change Limit134027665.95622502.9
3Display Results66660.0135076.9
 (SQL Overall)178691666.37228043.2
 
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.