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

267 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
gantries9141378(None) 
gauntries1046031gauntries
gentries91315261gentries
pantries101817391pantries
agentries1048232agentries
antres65021002_antr_es
banties94324762bant_ies
canaries10318942canaries
cantrips12318932cantrips
chantries14310292chantries
entries71523162_entries
gantlines1039332gantlines
gastrins9310122gastrins
gentrices1258912gentrices
granaries10159882granaries
panfries13149202panfries
panties94230932pant_ies
pastries101517422pastries
sentries81318052sentries
wastries111212882wastries
aeries64737783_a_eries
ambries111614553_ambries
anergies9310453_anergies
angaries9314393_angaries
angrier839023_angrier
angriest9310253_angriest
anomies93316993_anomies
antes56334323_ant__es
antics84621453_ant_ics
antired82316193_antired
antis55033313_ant_i_s
antre55224523_antr_e_
antrums969173_antrums
antsier7410773_antsier
antsiest8511463_antsiest
anurias7312253_anurias
aperies9423203_aperies
arteries8321483_arteries
attires72312953_attires
attrites8311563_attrites
attrits7310613_attrits
aunties73920073aunt_ies
bakeries14312193bakeries
bandies104124863ban_dies
banditries1345343banditries
banshies131110663banshies
batteries11615113batteries
bawdries14136843bawdries
bawties124214313bawt_ies
beaneries11310903beaneries
binaries10314183binaries
calories102919553calories
candies104125613can_dies
canities101519263canities
canneries11313083canneries
canonries1148413canonries
canopies12311853canopies
cantles94721413cant_les
cantraips13255273cantraips
cantraps12319113cantraps
cantrip112910043cantri_p
caries85147623ca__ries
carries94328013ca_rries
catteries11815523catteries
catties94023053ca_tties
cauteries11615393cauteries
centres93817123centr_es
centuries11311333centuries
chanties132615803chant_ies
contrives14311703contrives
countries11313613countries
dainties9312403daint_ies
dairies84217733da_iries
dandies94121443dan_dies
dataries9314033dataries
daubries1136743daubries
dauties83315763daut_ies
dawties113312703dawt_ies
deaneries10310833deaneries
eateries8324313eateries
entires71517783_entires
entrees71813773_entrees
errantries1044943errantries
factories14810093factories
faeries104118993fa_eries
fairies103516043fa_iries
fakeries1559833fakeries
fancies124018783fan_cies
fannies103415643fan_nies
fantails1139693fantails
fantasies1298853fantasies
fatties103018203fa_tties
fineries112416743fineries
flaneries1249563flaneries
gabies93820733ga__bies
gadflies1334733gadflies
gadgetries1344013gadgetries
gaieties9310183gaieties
galaxies1637163galaxies
galeres83514333galer_es
gallantries1254113gallantries
galleries10311703galleries
gallies84122713ga_llies
galores82614323galor_es
ganaches1437413ganaches
ganglier1047603ganglier
gangliest1137673gangliest
gangrel996143gangr_el
gangrels1094973gangrels
gangrenes1145063gangrenes
gangues9149753gan_gues
ganoids939333gan_oids
gantlet83616243gant_let
gantlets9308903gantlets
gantline9410903gantline
gantlopes1244283gantlopes
gantry103810113gantr__y
gasifies1238693gasifies
gastraea954383gastraea
gastraeas1063573gastraeas
gastrea847223gastr_ea
gastreas957253gastreas
gastric1038633gastri_c
gastrin839833gastri_n
gastritis1045673gastritis
gates65939513ga_t__es
gauderies1147743gauderies
gaudies9311973ga_udies
gawkies15429123ga_wkies
gayeties1236883gayeties
generics11118793generics
genies75324943gen__ies
genres75515623gen_r_es
gentes75324163gent__es
gentiles93713523gentiles
gentles83714343gent_les
gentrice1148813gentrice
gentrifies1446893gentrifies
gentrify1544683gentrify
gharries12318203gharries
glories81915913g_lories
gnathites1344233gnathites
gnattier934263gnattier
gnattiest1035383gnattiest
goitres8389563goitr_es
gramaries12128303gramaries
grannies9312613gran_nies
grantees92510973grant_ees
graperies1239613graperies
gumtrees1143883gumtrees
gunfires1235063gunfires
gunneries1047043gunneries
gunnies83413123gun_nies
gurries83515953g_urries
gynandries1552483gynandries
gyniatries1442973gyniatries
hankies143617763han_kies
hantles104117513hant_les
harries103525493ha_rries
henries102718283hen_ries
infantries1344693infantries
japeries17311463japeries
kanteles1238123kanteles
kauries113613193ka_uries
laetriles944663laetriles
laities7320343lait_ies
laniaries9411213laniaries
latrias71913213la_trias
latrines8515003la_trines
laundries1045563laundries
mandrils1138493mandrils
mantes84430783mant__es
mantids103113623mant_ids
mantis83926033mant_i_s
mantises10317923mantises
mantles94820703mant_les
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantr_as
mantric11311343mantri_c
manures9313353manur_es
marries93825283ma_rries
martyries1446563martyries
masteries111018493masteries
matres84522233ma_tr_es
matrices12312083ma_trices
matrixes1738063ma_trixes
nancies93516843nan_cies
nannies73015203nan_nies
naperies10313903naperies
nasties73520493nast_ies
pageantries1452983pageantries
paltrier1037523paltrier
paltriest1138603paltriest
pandies104224503pan_dies
panfried14134933panfried
pansies94521983pan_sies
pantie84326473pant_ie_
pantiles103617153pantiles
paries84742513pa__ries
parries93925843pa_rries
parties93230863part_ies
pasties94529813past_ies
patsies93919483pa_tsies
patties93425143pa_tties
pedantries1345683pedantries
peltries10313023peltries
penuries10311663penuries
pineries102419083pineries
poetries10315583poetries
psaltries1185743psaltries
punties94520783punt_ies
randies84225663ran_dies
reentries9311763reentries
retries74129073_retries
salaries8319573salaries
salties73725773salt_ies
saltires83112423saltires
sangrias938373sangrias
sanies63031953san__ies
sanitaries1049913sanitaries
sanities81219773sanities
santerias9311843santerias
santims9312603sant_ims
santirs7312963sant_irs
satires72617573sa_tires
sauries72821623sa_uries
savories11311273savories
scanties103215423scant_ies
shanties113116583shant_ies
sundries9312023sundries
tanistries1047063tanistries
tanneries9310423tanneries
tansies74521243tan_sies
tantivies1247103tantivies
tantras73112093tantr_as
tantric939583tantri_c
tantrism1048373tantrism
tantrisms1146323tantrisms
tantrums1045113tantrums
tarries73324263ta_rries
tatties74120343ta_tties
tawdries12136083tawdries
tenantries1045673tenantries
tries55742813___tries
truantries1044023truantries
unties64326923_unt_ies
untried82615853_untried
untrims938613_untrims
vagaries12310293vagaries
vanities111414493vanities
vanitories1346903vanitories
vantages12119023vantages
varies94330873va__ries
veneries112815033veneries
vestries11314053vestries
vineries112716043vineries
wantages12109023wantages
wasteries121115343wasteries
wastrie101210303wastrie_
wineries112316533wineries
wintrier1136873wintrier
wintriest1238153wintriest
xanthines1966723xanthines
xanthins1846943xanthins
yantras10259003yantr_as
zanies153219673zan__ies

Search took 7 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.420425454.8
2DLD Change Limit1461622676.37622923.8
3Display Results2672670.1102427.3
 (SQL Overall)1786912676.90625874.7
 
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.