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

96 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
gurnard94477(None) 
gurnards1043631gurnards
guard74415542gu__ard
guisard954202guisard
airward1148133airward
aurar54420253aur_ar_
barnyard1443783barnyard
briard94311293_briard
burned95818963burn_ed
burner83819203burner_
burners94115673burners
bursar85413253bursar_
bursars94510893bursars
bursary12397583bursary
bustard10389723bustard
buzzard1844273buzzard
canard9314763_canard
curara83712203cur_ara
curare84916953cur_are
curari84414403cur_ari
custard10389973custard
drunkard1441553drunkard
dullard936603dullard
durbar968723durbar_
durbars1077973durbars
durned84113173durn_ed
forward1438293forward
furnace1235943furnace
furnaced1443513furnaced
gabbard1336553gabbard
garboard1247243garboard
garland948703garland
garner73917003garner_
garnered10247113garnered
garners83815983garners
girned84010513girn_ed
gizzard17114203gizzard
gnar56021383g__nar_
gnarl65115573g__narl
gnarr64810693g__narr
gnars66718853g__nars
goliard936073goliard
gonad75216053g_ona_d
gormand1157453gormand
gourmand1243263gourmand
grad66829863g_r_a_d
granary1157793granary
grand75122693g_r_and
grunted9339283grunted
guanaco1064583guanaco
guanase836213guanase
guanay1037913guana_y
guanays1134953guanays
guar56923293gu__ar_
guards84611563gu__ards
guars65021043gu__ars
guisards1043603guisards
guitar7117443guitar_
guitars8116853guitars
gular6314833gu_lar_
gunned83513093gu_nned
gunner73813983gunner_
gunners83111723gunners
gunnery11376363gunnery
gurged95513363gur_ged
gurgled10399123gurgled
gurnet74920873gurn_et
gurnets84010793gurnets
gurney10429413gurn_ey
gurneys11406463gurneys
gurry94515413gur__ry
lunar57017313lu_nar_
lunars65012813lu_nars
mustard10359533mustard
nard56634453___nard
ourari63413543our_ari
outward11811403outward
quinary1936933quinary
reynard1135123reynard
sunward1137653sunward
surname937603surname
surnamed1135113surnamed
ternary1038343ternary
turbary1236383turbary
turned73914473turn_ed
turner63914613turner_
turners73912893turners
turnery10357423turnery
ulnad65611453_ulna_d
ulnar56013983_ulnar_
unarm7314453_u_narm
unary8315993_u_nary
upward12147163_upward
urare56322553_ur_are
urari54619963_ur_ari
urinary1037243_urinary

Search took 9 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.1431249587.4
2DLD Change Limit134027967.95016858.7
3Display Results96960.0501920.0
 (SQL Overall)178691968.14321944.1
 
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.