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

193 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
general8101093(None) 
genera71211711genera_
generals9109331generals
central93114472central
enteral73516442_enteral
federal1148532federal
funeral1037622funeral
generable1238662generable
generalcy1543422generalcy
generally1347342generally
generate9312902generate
generic101310752generic
generical1246992generical
geneva1085852geneva_
genevas1185252genevas
genial74917612gen_ial
genital849792genital
gomeral1038832gomeral
mineral9312732mineral
renewal1038702renewal
several1039532several
venereal1145082venereal
ventral103612172ventral
adnexal1543823adnexal
agential958153agential
anneal64812293anne_al
antral65719413_antral
anural65714743_anural
apneal83411123apne_al
apteral9311523apteral
benthal1247953benthal
benzal1739643ben_zal
cameral11311283cameral
censual937663censual
cental84420963cen_tal
centra84113883centra_
centrals102712033centrals
cereal8315833cere_al
cerebral1266183cerebral
cuneal8611513cune_al
deferral1244353deferral
demersal1145263demersal
denial74720513den_ial
dental74319173den_tal
dentural948083dentural
deverbal1444483deverbal
dextral1577003dextral
emerald1046923_emerald
enema7612743_enema_
enemas8812003_enemas
energy10137513_energy
engrail846263_engrail
engram9310653_engram
enrol51014283_en_rol
entera64216833_entera_
enthral103410933_enthral
entrap8710563_entrap
enwrap1185213_enwrap
estral64716513_estral
eternal72910893_eternal
federals1247303federals
femoral1238723femoral
fenestral1244113fenestral
feral85424653__feral
funerals1146453funerals
funereal1143943funereal
gametal1037603gametal
gangrel996143gangrel
gastral8329553gastral
geegaw1142853ge_egaw
geminal10109903geminal
gender83517933gender__
gendered11258873gendered
genders93616783gender_s
gene56237223gene___
generalise11178123generalise
generalist11169423generalist
generality1446193generality
generalize20198453generalize
generated11310203generated
generates10312713generates
generator1067593generator
generics11118793generics
generous939773generous
genes65133093gene__s
geneses82613523geneses
genesis82510823genesis
genet66038683gene__t
genetic101211783genetic
genetical1247573genetical
genets75716663gene_ts
genette838863genette
genipap1243123genipap
genitals937243genitals
genoa64315823gen_oa_
genoas74013623gen_oas
genogram1246733genogram
genre66016803gen_r_e
genres75515623gen_res
genro64914033gen_r_o
genros74211333gen_ros
genteel836753genteel
gentian8310103gentian
gentil74115123gen_til
gentry103410443gentr_y
genua64614153gen_ua_
geoidal936713geoidal
gerah9315303g__erah
gerbera1034773gerbera_
gerberas1144963gerberas
gesneria944053gesneria
gesneriad1142323gesneriad
gestural946033gestural
gherao1036753g_herao
gingal81010153gin_gal
gnarl65115573g_nar_l
gomerals1147443gomerals
gomerel1036393gomerel
gomeril1047383gomeril
gonadal956523gonadal
goner66025163goner__
goners74420173goner_s
gooral7310463g_ooral
goral65125753g__oral
gunmetal1143213gunmetal
gyral94412783g__yral
humeral1238563humeral
lateral7313573lateral
liberal9310193liberal
lineal65616023line_al
literal7613273literal
menial84223033men_ial
menorah1247933menorah
mensal84615653men_sal
mensural1046223mensural
mental84521603men_tal
minerals10311373minerals
moneran9311113moneran
nerol51017813__nerol
neural6311993ne_ural
neutral737923neutral
nonoral7313603nonoral
numeral939083numeral
outgeneral1161963outgeneral
penal75228373pen__al
penial84120893pen_ial
peroral9314793peroral
peytral1287503peytral
pineal84817683pine_al
puberal1147773puberal
referral1144403referral
renal55929503ren__al
renewals1137273renewals
rental63922023ren_tal
repeal84718283repe_al
reseal64819643rese_al
retral64419743re_tral
reveal94115053reve_al
reversal1145843reversal
ruderal837373ruderal
scleral937863scleral
segetal868383segetal
sendal73314993sen_dal
seneca839793seneca_
senecas939013senecas
senega738173senega_
senegas837253senegas
senora63216153senora_
senoras72714953senoras
sensual738053sensual
seral56336383__seral
severals1137593severals
spheral1238423spheral
teleran7510173teleran
tendril836783tendril
tenebrae1044873tenebrae
tenurial847703tenurial
tineal66216163tine_al
unreal64414453_unreal
ureteral856233ureteral
vegetal1156303vegetal
venal85523213ven__al
venerable1438483venerable
venerably1746423venerably
venerate11312903venerate
venery123710663vener_y
venial94218283ven_ial
ventrals112910003ventrals
vesperal1344883vesperal
vestral104111013vestral
veteran1039353veteran
vineal94814743vine_al
xenial133414903xen_ial

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271936.29621287.6
3Display Results1931930.0633063.5
 (SQL Overall)1786911936.51527427.6
 
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.