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 “giants” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
giants7471350(None) 
giant65430591giant_
grants73722471grants
alants67722022alants
ants47243472__ants
bints76130182bi_nts
bionts8612392bionts
brants85723052brants
cants77036942_cants
chants115020392chants
dints67431312di_nts
faints94818782faints
fiats85324482fia_ts
gains65729512gain_s
gainst74914692gainst
gaits65726012g_aits
gangs76222572g_angs
gasts66628632g_asts
gats56753442g_a_ts
gelants82611442gelants
gents65729612g_ents
ghats95818612gha_ts
ghauts10447782ghauts
giantess933892giantess
giantism1155382giantism
gifts96214962gi_fts
gigots83911952gigots
gilts64924262gi_lts
ginks104319562gi_nks
gins55543952gi_n_s
girns64516802girn_s
girts65423622gi_rts
gists66026192gi_sts
gitanos837172gitanos
gits55744592gi__ts
glands85314402glands
glans65125832glan_s
glints75714212glints
gnats65217712gna_ts
goats65527302goa_ts
grafts105013252grafts
grands84218242grands
grans64832542gran_s
grant64840022grant_
grunts75511852grunts
guanos73811992guanos
guans64419442guan_s
haints94417582haints
hants86335402_hants
hints87330622hi_nts
kiangs11378362kiangs
lianas63713382lianas
lianes63819322lianes
liangs74410592liangs
lints57137192li_nts
mints76834042mi_nts
paints85921832paints
pants76536922_pants
pianos84315932pianos
pians75126962pian_s
pints75936222pi_nts
plants84921802plants
quants153614142quants
rants55935342_rants
riant55833152riant_
saints65122422saints
scants85219722scants
slants64819082slants
taints64520532taints
tints56030922ti_nts
viands1047812viands
wants87932212_wants

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit82551722.15638289.0
3Display Results72720.0164500.0
 (SQL Overall)178691722.29577861.0
 
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.