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 “gentries” 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
gentries9131526(None) 
agentries1048231agentries
entries71523161_entries
gantries91413781gantries
gentrices1258911gentrices
sentries81318051sentries
centres93817122centr_es
centuries11311332centuries
entires71517782_entires
entrees71813772_entrees
gauntries1046032gauntries
generics11118792generics
genies75324942gen__ies
genres75515622gen_r_es
gentes75324162gent__es
gentiles93713522gentiles
gentles83714342gent_les
gentrice1148812gentrice
gentrifies1446892gentrifies
gentrify1544682gentrify
henries102718282hen_ries
pantries101817392pantries
peltries10313022peltries
penuries10311662penuries
reentries9311762reentries
retries74129072re_tries
veneries112815032veneries
vestries11314052vestries
aeries64737783ae__ries
agencies1138743agen_cies
agentives1346443agentives
antres65021003_antr_es
aunties73920073aunt_ies
banties94324763bant_ies
beaneries11310903beaneries
belfries1336983belfries
bennies93917313ben_nies
berries94423553be_rries
bestrides1237913bestrides
binaries10314183binaries
canaries10318943canaries
cantrips12318933cantrips
celeries10316313celeries
centares102913893centares
centauries1245533centauries
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
centones10313663centones
centrals102712033centrals
centre84316643centr_e_
centred103411683centr_ed
centric11312403centri_c
centring112112953centring
centrings12227603centrings
centrioles1245803centrioles
centrism1249643centrism
centrisms1348053centrisms
centrist10314863centrist
centrists11410233centrists
centroids1247043centroids
centrums1236913centrums
chantries14310293chantries
contrives14311703contrives
countries11313613countries
deaneries10310833deaneries
dearies83526273de_aries
decries103319803de_cries
decuries11312223decuries
deities82621923deit_ies
denarius948813denarius
dendrites1147933dendrites
denies74729643den__ies
dentils84115583dent_ils
dentines93418403dentines
dentins83419223dent_ins
dentures9312453dentures
derries83124623de_rries
descries11311923descries
destrier9311823destrier
destriers1038143destriers
dextrines1798313dextrines
dextrins16117823dextrins
eateries8324313_eateries
emeries91620023_emeries
endrins8312163_endrins
enemies9313693_enemies
energies9310783_energies
enskies1138573_enskies
entails7912823_entails
entases72816273_entases
enterics10312853_enterics
entices91616333_entices
entire61617703_entire_
entities8617413_entities
entoils7810733_entoils
entrails8310163_entrails
entrains8312963_entrains
entraps9109763_entraps
entree61817883_entr_ee
entropies11411023_entropies
entwines1148753_entwines
enures63919713_enur_es
envies9314053_en_vies
estrins7315853_estrins
eyries93816813_e_yries
ferneries1239043ferneries
ferries103521083fe_rries
fewtrils1443203fewtrils
fineries112416743fineries
gantlines1039333gantlines
gastrins9310123gastrins
gematrias1275393gematrias
gendarmes1343923gendarmes
genderizes2176003genderizes
generals9109333generals
generates10312713generates
generic101310753generi_c
generous939773generous
genes65133093gen___es
geneses82613523gen_eses
genesis82510823genesi_s
genetics11128613genetics
genettes938303genettes
genie66124923gen__ie_
genips9469943gen__ips
genitives1346663genitives
genitures1046123genitures
genius74512923gen__ius
geniuses935933geniuses
genocides1345003genocides
genoise839423gen_oise
genoises939253genoises
genomes103611703gen_omes
genomics1345713genomics
genotypes1544683genotypes
genre66016803gen_r_e_
genros74211333gen_r_os
genteel836753gent_eel
gentian8310103gent_ian
gentians937563gentians
gentil74115123gent_i_l
gentile83515293gent_ile
gentle74014513gent_le_
gentled9389093gent_led
gentler8378953gent_ler
gentlest93410573gent_lest
gentling1048453gentling
gentoos838633gent_oos
gentrified1545673gentrified
gentrifier1444813gentrifier
gentrifiers1543003gentrifiers
gentry103410443gentr__y
gents65729613gent___s
genuses83510883gen_uses
geometries13139253geometries
geotaxes1644743geotaxes
gestates93213733gestates
gestes75721393gest__es
gestures9310013gestures
gharries12318203gharries
glories81915913g_lories
goitres8389563goitr_es
granaries10159883granaries
greeneries1167073greeneries
gumtrees1143883gumtrees
gunfires1235063gunfires
gunneries1047043gunneries
gunnies83413123gun_nies
gurries83515953g_urries
gyniatries1442973gyniatries
hearties11315413hearties
helotries1269563helotries
henneries1248643henneries
herries104025073he_rries
jennies143511623jen_nies
jerries143817513je_rries
jetties143613123je_tties
kentes105118653kent__es
kerries113317913ke_rries
lefties10312073left_ies
legendries1243823legendries
lenities8315943lenities
lentils73912973lent_ils
lentoids947443lentoids
lienteries1047563lienteries
memories121214353memories
mentees93214503ment_ees
metres85121563me_tr_es
metrics11312363me_trics
misentries1247823misentries
nectaries1149813nectaries
nonentries1048283nonentries
oestrins8312673oestrins
pageantries1452983pageantries
panfries13149203panfries
panties94230933pant_ies
pastries101517423pastries
pedantries1345683pedantries
peeries93623023pe_eries
pennies94218813pen_nies
pentanes10316083pentanes
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
perries93226603pe_rries
pineries102419083pineries
plenaries11410383plenaries
plenties10314693plent_ies
poetries10315583poetries
punties94520783punt_ies
reburies10311143reburies
rectories11314643rectories
rectrices1338873rectrices
redries83721713re_dries
refries104419733re_fries
rentes65431193rent__es
rentier73618223rent_ier
rentiers83311763rent_iers
restrikes1339413restrikes
restrives12310663restrives
reties65436193re_t_ies
retires74726213re_tires
retried84419153re_tried
retrims93612373re_trims
reveries112518513reveries
sceneries1149393sceneries
sectaries11312243sectaries
senarius8310103senarius
senores73218113senor_es
series64540973se__ries
serries73925353se_rries
subentries1246423subentries
sundries9312023sundries
tectrices1346253tectrices
tenantries1045673tenantries
tendrils946443tendrils
tennies73017973ten_nies
tenorites9311093tenorites
tentages91011043tentages
tentie62521183tent_ie_
tentier73815923tent_ier
tentiest82115613tent_iest
tenures7412013tenur_es
ternaries9311643ternaries
terries73425633te_rries
tetris62816293te_tri_s
tries55742813___tries
twenties1137503twent_ies
unties64326923_unt_ies
untried82615853_untried
untrims938613_untrims
veeries102916893ve_eries
venires103012453venir_es
ventages12119773ventages
ventails1139823ventails
ventrals112910003ventrals
ventricles1544523ventricles
ventures11311493ventures
venturis1138193venturi_s
vineries112716043vineries
wastries111212883wastries
wearies103020223we_aries
wineries112316533wineries
wintrier1136873wintrier
wintriest1238153wintriest
yentes95517603yent__es

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.53019410.6
3Display Results2672670.1102427.3
 (SQL Overall)1786912678.06322161.9
 
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.