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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

212 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
gardant931446(None) 
guardant1046441guardant
ardent73022612_ardent
arrant6623252_arrant
gallant83517112gallant
garda7316762garda__
gardai839662garda_i
garden84215082garden_
gardens93312092gardens
garland948702garland
garment10315232garment
grant64840022g_r_ant
guardants1143792guardants
mordant10312402mordant
regardant1145442regardant
sardana838642sardana
variant10316802variant
verdant11313292verdant
warrant10614242warrant
abradant1147213abradant
adapt81218553_a_dapt
alant55742293_a_lant
andante8311273_andante
arcana8912583_arcana
arcane81216743_arcane
argent74023663_argent
arhat8327093_arha_t
aroint6328153_aroint
aroynt9312893_aroynt
arpent84822093_arpent
askant10412713_askant
aslant6317753_aslant
avant86224663_a_vant
bandana10179463bandana
barding113822893barding
barman103519703barman_
brant74742173_br_ant
cadent94120353ca_dent
callant94121223callant
candent10417363candent
carat75048793car_a_t
carcanet12316343carcanet
carding113922433carding
cardon94120853cardon_
cardons104519933cardons
carman103920743carman_
currant9314173currant
dormant102814373dormant
errant6618733_errant
farding123716743farding
fondant11311143fondant
formant123416003formant
gabbart1248883gabbart
gadding113411453gadding
gadget93616173ga_dget
gagman103811243gagman_
galavant1246353galavant
galivant1247083galivant
gallants93310373gallants
garage8314513gar_age
garbage1138053garbage
garbagy1444243garbagy
garbanzo2042583garbanzo
garbing113613273garbing
garcon92912483garcon_
garcons102411643garcons
gardened1137003gardened
gardener1037103gardener
gardenia1045383gardenia
garganey1344883garganey
gargantua1142463gargantua
garget84327273gar_get
garlands1038323garlands
garments1139963garments
garnet73928413gar_net
garni6315703gar__ni
garret74426553gar_ret
garring93116713garring
garron73113493garron_
garrons82713463garrons
gasman92911743gasman_
gaunt65430403ga__unt
gaydar1135503gayda_r
gaydars1235803gaydars
gelant72821673g_elant
gellant83214053gellant
gerent73223093ger_ent
german9611983german_
germane1049663germane
germans1079463germans
giant65430593g__iant
girding103611883girding
gormand1157453gormand
gradate9511223gradate
gradient10310373gradient
gradin83517483gradin_
gradine93317033gradine
grading103918713grading
gradins93416233gradins
graduand1143893graduand
graft95327203g_r_aft
gran56335013g_r_an_
grana65722093g_r_ana
grand75122693g_r_and
grandaunt1144703grandaunt
grans64832543g_r_ans
grants73722473g_r_ants
grat55651283g_r_a_t
great66034243g_rea_t
groan65618423g_roan_
groans74815063g_roans
groat65531973g_roa_t
grunt65523543g_r_unt
guarana886303guar_ana
guarani8106273guar_ani
guaranty1244153guar_anty
guardian1045113guardian_
guardians1143913guardians
guarding1136523guarding
hardass1139753hardass
harden105718533harden_
hardens113815023hardens
hardest113118413hardest
hardhat14411023hardhat
hardpan1336443hardpan_
hardpans1436453hardpans
hardset113415833hardset
hariana10310243hariana
hydrant1489053hydrant
jordan1468063jordan_
jordans1566833jordans
jurant134216553jur_ant
karat96837593kar_a_t
larding92917873larding
lardon74415063lardon_
lardons83914493lardons
lariat6629043laria_t
lurdan738363lurdan_
lurdane835983lurdane
lurdans837073lurdans
maranta9311693mar_anta
margent10316693margent
marrano939423marrano
mordants1137143mordants
mordent10313993mordent
nardine82712573nardine
natant6318733na_tant
oxidant1547363oxidant
pageant10312783pageant
pandani1039903pandani
parang93715513par_ang
pardah123412823parda_h
pardahs13289673pardahs
pardine103616723pardine
pardon94618733pardon_
pardons103817623pardons
parent83230423par_ent
parfait12312053parfait
parian83223963parian_
parians93519733parians
parlante1039683parlante
partan83820563partan_
partans94418283partans
passant9813943passant
pedant9319493_pedant
pendant10314853pendant
quadrant1858083quadrant
radiant82817133radiant
rampant11312173rampant
randan7315253randan_
randans8313213randans
rant45864673__r_ant
retardant1046833retardant
riant55833153__riant
saltant7316773saltant
saran53730303sar_an_
sarans64224433sar_ans
sardanas937813sardanas
sardar73013173sarda_r
sardars83112903sardars
sardine83317393sardine
sarment9318763sarment
savant9416043sa_vant
servant10313623servant
taggant9310213taggant
tarpan82814293tarpan_
tarpans92513533tarpans
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tarzan152910753tarzan_
tarzans16329923tarzans
truant6315783_truant
tyrant9315333tyr_ant
vacant11415133va_cant
vagrant11410663vagrant
valiant10314623valiant
variants1139203variants
varment12313243varment
varmint12311683varmint
versant10313833versant
warden104515513warden_
wardens113711903wardens
warding123918143warding
warrants1168503warrants
warranty1465043warranty
yardage1235733yardage
yardarm13114533yardarm
yarding123413143yarding
yardland1343763yardland
yardman1335913yardman_
yardwand1642743yardwand

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272127.53017799.1
3Display Results2122120.0802650.0
 (SQL Overall)1786912127.76623009.4
 
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.