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

85 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
galliard1012575(None) 
galliards1194541galliards
halliard12125961halliard
ballyard1445892ballyard
billiard1145872billiard
galliass935422galliass
gallied94115002galli_ed
goliard936072g_oliard
halliards13104932halliards
mallard10310272mall_ard
milliard1147032milliard
allied74217153_alli_ed
ballad94315323ball_a_d
ballpark1643753ballpark
ballyards1544993ballyards
billiards1245023billiards
bollard103210503boll_ard
callboard1445663callboard
collard103712923coll_ard
dallied93713613dalli_ed
dallier84215373dallier_
dalliers93610613dalliers
dullard936603dull_ard
fallboard1545053fallboard
gabbard1336553ga_bbard
gallant83517113gall_ant
gallate83417133gall_ate
galleass935053galleass
galled84622863gall__ed
gallery11468743gall_ery
galleted1038223galleted
gallic9411643galli__c
gallica1047463galli_ca
gallican1155333gallican
gallicas1136933gallicas
gallies84122713galli_es
galling93921963galli_ng
galliot82214133galli_ot
galliots9228683galliots
gallipot1145943gallipot
gallium1037943galli_um
galliums1145963galliums
gallivant1344493gallivant
galliwasp1541653galliwasp
galloped12107153galloped
gallused1034193gallused
gangliar1064123gangliar_
garboard1247243garboard
garland948703garl_and
gillied95512313gilli_ed
goalward1343493goalward
goliards1045133g_oliards
gullied93812063gulli_ed
hallmark1744213hallmark
halloaed121510153halloaed
halyard1476973ha_lyard
haulyard1583223haulyard
kailyard1643503kailyard
kaleyard1683573kaleyard
lalland83810183lall_and
laniard868523la_niard
liard65418593___liard
mallards1138323mall_ards
milliards1246193milliards
milliare1039153milliare
milliary1346853milliary
paillard1146263paillard
pallia83015593pallia__
pallial92911253pallia_l
palliate10311893palliate
palliated1238493palliated
pallid93915283palli__d
pallier94417163pallier_
pollard103511143poll_ard
rallied83514083ralli_ed
rallier73816273rallier_
ralliers84010833ralliers
sallied83316953salli_ed
sallier73320423sallier_
salliers83613343salliers
tallied83314753talli_ed
tallier72817213tallier_
talliers83711373talliers
wallboard1545023wallboard
willyard1543963willyard

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 Filter1786911461620.656272394.8
2DLD Change Limit146162856.58022213.1
3Display Results85850.0302833.3
 (SQL Overall)178691857.26624592.8
 
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.