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
gantries9141380(None) 
gauntries1046051gauntries
gentries91315271gentries
pantries101817391pantries
agentries1048242agentries
antres65021002_antr_es
banties94324762bant_ies
canaries10318942canaries
cantrips12318932cantrips
chantries14310292chantries
entries71523162_entries
gantlines1039332gantlines
gastrins9310132gastrins
gentrices1258922gentrices
granaries10159882granaries
panfries13149212panfries
panties94230932pant_ies
pastries101517422pastries
sentries81318062sentries
wastries111212882wastries
aeries64737783_a_eries
ambries111614563_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
anurias7312263_anurias
aperies9423203_aperies
arteries8321513_arteries
attires72312953_attires
attrites8311583_attrites
attrits7310633_attrits
aunties73920073aunt_ies
bakeries14312203bakeries
bandies104124863ban_dies
banditries1345353banditries
banshies131110663banshies
batteries11615133batteries
bawdries14136843bawdries
bawties124214313bawt_ies
beaneries11310903beaneries
binaries10314183binaries
calories102919563calories
candies104125613can_dies
canities101519263canities
canneries11313083canneries
canonries1148413canonries
canopies12311853canopies
cantles94721413cant_les
cantraips13255273cantraips
cantraps12319113cantraps
cantrip112910043cantri_p
caries85147623ca__ries
carries94328013ca_rries
catteries11815553catteries
catties94023053ca_tties
cauteries11615403cauteries
centres93817123centr_es
centuries11311333centuries
chanties132615803chant_ies
contrives14311703contrives
countries11313613countries
dainties9312403daint_ies
dairies84217733da_iries
dandies94121443dan_dies
dataries9314033dataries
daubries1136743daubries
dauties83315763daut_ies
dawties113312703dawt_ies
deaneries10310833deaneries
eateries8324323eateries
entires71517783_entires
entrees71813773_entrees
errantries1044943errantries
factories14810123factories
faeries104118993fa_eries
fairies103516043fa_iries
fakeries1559833fakeries
fancies124018783fan_cies
fannies103415643fan_nies
fantails1139693fantails
fantasies1298853fantasies
fatties103018203fa_tties
fineries112416753fineries
flaneries1249563flaneries
gabies93820733ga__bies
gadflies1334733gadflies
gadgetries1344033gadgetries
gaieties9310183gaieties
galaxies1637173galaxies
galeres83514343galer_es
gallantries1254143gallantries
galleries10311713galleries
gallies84122713ga_llies
galores82614343galor_es
ganaches1437433ganaches
ganglier1047603ganglier
gangliest1137673gangliest
gangrel996143gangr_el
gangrels1094973gangrels
gangrenes1145073gangrenes
gangues9149753gan_gues
ganoids939333gan_oids
gantlet83616243gant_let
gantlets9308903gantlets
gantline9410903gantline
gantlopes1244283gantlopes
gantry103810113gantr__y
gasifies1238693gasifies
gastraea954413gastraea
gastraeas1063593gastraeas
gastrea847253gastr_ea
gastreas957273gastreas
gastric1038643gastri_c
gastrin839833gastri_n
gastritis1045703gastritis
gates65939513ga_t__es
gauderies1147743gauderies
gaudies9311973ga_udies
gawkies15429123ga_wkies
gayeties1236883gayeties
generics11118803generics
genies75324943gen__ies
genres75515623gen_r_es
gentes75324163gent__es
gentiles93713523gentiles
gentles83714343gent_les
gentrice1148813gentrice
gentrifies1446903gentrifies
gentrify1544683gentrify
gharries12318223gharries
glories81915923g_lories
gnathites1344233gnathites
gnattier934263gnattier
gnattiest1035383gnattiest
goitres8389563goitr_es
gramaries12128313gramaries
grannies9312613gran_nies
grantees92510973grant_ees
graperies1239613graperies
gumtrees1143883gumtrees
gunfires1235063gunfires
gunneries1047043gunneries
gunnies83413123gun_nies
gurries83515953g_urries
gynandries1552483gynandries
gyniatries1442973gyniatries
hankies143617763han_kies
hantles104117513hant_les
harries103525503ha_rries
henries102718283hen_ries
infantries1344693infantries
japeries17311463japeries
kanteles1238123kanteles
kauries113613193ka_uries
laetriles944673laetriles
laities7320343lait_ies
laniaries9411223laniaries
latrias71913213la_trias
latrines8515013la_trines
laundries1045563laundries
mandrils1138493mandrils
mantes84430783mant__es
mantids103113623mant_ids
mantis83926033mant_i_s
mantises10317923mantises
mantles94820703mant_les
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantr_as
mantric11311353mantri_c
manures9313353manur_es
marries93825293ma_rries
martyries1446563martyries
masteries111018513masteries
matres84522233ma_tr_es
matrices12312083ma_trices
matrixes1738063ma_trixes
nancies93516843nan_cies
nannies73015203nan_nies
naperies10313903naperies
nasties73520493nast_ies
pageantries1452983pageantries
paltrier1037543paltrier
paltriest1138603paltriest
pandies104224503pan_dies
panfried14134933panfried
pansies94521983pan_sies
pantie84326473pant_ie_
pantiles103617163pantiles
paries84742523pa__ries
parries93925853pa_rries
parties93230873part_ies
pasties94529813past_ies
patsies93919483pa_tsies
patties93425143pa_tties
pedantries1345693pedantries
peltries10313023peltries
penuries10311663penuries
pineries102419083pineries
poetries10315583poetries
psaltries1185743psaltries
punties94520783punt_ies
randies84225663ran_dies
reentries9311773reentries
retries74129073_retries
salaries8319593salaries
salties73725773salt_ies
saltires83112433saltires
sangrias938373sangrias
sanies63031953san__ies
sanitaries1049913sanitaries
sanities81219773sanities
santerias9311863santerias
santims9312603sant_ims
santirs7312963sant_irs
satires72617573sa_tires
sauries72821623sa_uries
savories11311273savories
scanties103215423scant_ies
shanties113116593shant_ies
sundries9312023sundries
tanistries1047073tanistries
tanneries9310423tanneries
tansies74521243tan_sies
tantivies1247103tantivies
tantras73112093tantr_as
tantric939593tantri_c
tantrism1048373tantrism
tantrisms1146323tantrisms
tantrums1045113tantrums
tarries73324263ta_rries
tatties74120343ta_tties
tawdries12136083tawdries
tenantries1045673tenantries
tries55742813___tries
truantries1044033truantries
unties64326923_unt_ies
untried82615853_untried
untrims938613_untrims
vagaries12310293vagaries
vanities111414493vanities
vanitories1346913vanitories
vantages12119023vantages
varies94330873va__ries
veneries112815033veneries
vestries11314053vestries
vineries112716043vineries
wantages12109023wantages
wasteries121115363wasteries
wastrie101210303wastrie_
wineries112316533wineries
wintrier1136873wintrier
wintriest1238153wintriest
xanthines1966723xanthines
xanthins1846943xanthins
yantras10259003yantr_as
zanies153219673zan__ies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622677.84318636.0
3Display Results2672670.1062518.9
 (SQL Overall)1786912678.37221343.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.