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

53 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
guardian104511(None) 
guardians1143911guardians
giardia945562giardia_
giardias1045022giardias
guardant1046442guard_ant
guarding1136522guarding
guardsman1342522guardsman
acaridan1165233acaridan
agrarian948253agrar_ian
aquarian1747013aquar_ian
boardman1344393boardman
cardia9916383_cardia_
cardiac1278823_cardiac
cardiae10713713_cardiae
cardias10715123_cardias
cardigan1245623_cardigan
durian7312003du_r_ian
garda7316763g_ard_a_
gardai839663g_ard_ai
gardant9314463g_ard_ant
garden84215083g_ard_en
gerardia1044673gerardia_
gerardias1144403gerardias
gharial1137343ghar_ial
gradin83517483gra_di_n
guaiac946153gua__iac
guanidin1044193guanidin
guanin7610803gua_ni_n
guarana886303guar__ana
guaranas995943guaranas
guarani8106273guar__ani
guard74415543guard___
guardants1143793guard_ants
guarddog1241683guarddog
guarded1036153guard_ed
guarder936463guard_er
guarders1035883guarders
guardrail1151903guardrail
guards84611573guard__s
guardsmen1342623guardsmen
guerdon944343guerd_on
gueridon1043033gueridon
hardpan1336443_hardpan
iguanian943553igua_nian
lunarian847293lunar_ian
lurdan738363lu_rd_an
martian93514683_martian
ovarian1037643ovar_ian
parian83223963_par_ian
quartan1636423quar_tan
radian74117273_ra_dian
saurian739913saur_ian
yardman1335913_yardman

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.406440125.6
2DLD Change Limit146162537.34319904.9
3Display Results53530.0301766.7
 (SQL Overall)178691537.77922970.9
 
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.