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

47 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
guardians114391(None) 
guardian1045111guardian_
giardias1045022giardia_s
guardant1046442guard_ant
guardants1143792guard_ants
guarding1136522guardi_ng
acaridans1254033acaridans
agrarians1045793agrar_ians
aquarians1845873aquar_ians
cardiacs1376913_cardiacs
cardias10715113_cardia_s
cardigans1345153_cardigans
durians839573du_r_ians
gardant9314463g_ard_ant
gardens93312093g_ard_ens
gerardias1144403gerardia_s
gharials1245123ghar_ials
giardia945563giardia__
giardiases1242323giardiases
giardiasis1251793giardiasis
gradins93416233gra_di_ns
guaiacs1054353gua__iacs
guanidins1143663guanidins
guanins8810013gua_ni_ns
guarana886303guar__ana
guaranas995943guar__anas
guarani8106273guar__ani
guaranis996863guar__anis
guarddogs1351513guarddogs
guarders1035883guard_ers
guardianship19132673guardianship
guardrail1151903guardrail
guardrails1251773guardrails
guards84611573guard___s
guardsman1342523guardsman_
guerdons1044233guerd_ons
gueridons1142803gueridons
hardpans1436453_hardpans
iguanians1042583igua_nians
lunarians945513lunar_ians
lurdans837073lu_rd_ans
martians103111613_martians
parians93519733_par_ians
quadrans1866363qua_drans
quartans1736283quar_tans
radians83013823_ra_dians
saurians837763saur_ians

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 Filter1786911486410.453394461.4
2DLD Change Limit148641478.22018082.8
3Display Results47470.0133615.4
 (SQL Overall)178691478.68620572.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.