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

322 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
fertile1031173(None) 
centile94217182centile
febrile1237152febrile
feriae95618602fer_iae
ferine96422582fer_ine
ferlie92814052ferli_e
ferrite103312752ferrite
ferrule1035862ferrule
fertilely1544262fertilely
fertilize2147522fertilize
ferule93413202fer_ule
festive1339772festive
fettle93713122fe_ttle
fictile1238022fictile
furtive1337172furtive
futile93914952f_utile
gentile83515292gentile
infertile1248672infertile
reptile93914082reptile
retile65929672re_tile
sectile9311972sectile
servile10310642servile
sextile1438572sextile
textile1437222textile
tortile7313192tortile
unfertile1246412unfertile
verbile1249862verbile
aedile73716653ae_dile
aerie54634603aer_i_e
aerily93017013aer_ily
afebrile1342683afebrile
aftertime1445473aftertime
airtime948063airtime
article9310923_article
artily92814713_artily
avertible1495233avertible
bastile9313913bastile
bedtime1236973bedtime
beetle8311673beet_le
beguile1056933beguile
berime105317333ber_ime
berline93716853berline
bernicle1245443bernicle
besmile1137463besmile
betide95115973be_tide
betime105914833be_time
betise85616273be_tise
centiles103615813centiles
centime114513033centime
cerise84822043cer_ise
cerite84724873cer_ite
certify1546243certify
cervine122610803cervine
dartle73714833dart_le
decile94619213de_cile
defile105216663de_file
denticle1137773denticle
dentil74017883dentil_
dentiled1039743dentiled
dentils84115583dentils
dentine83320243dentine
derail74218813derail_
derailed102410403derailed
derails84216393derails
deride84420033der_ide
derive103817043der_ive
destine83719953destine
dirtily1138583dirtily
ductile1048473ductile
edile64819493_e_dile
eerie55228533eer_i_e
eerily92913563eer_ily
ensile62616473_ensile
entice81316863_entice
entire61617703_entire
entitle7610293_entitle
erectile1039513erectile
ermine8416923_ermine
erotize16311653_erotize
ervil8310303_ervil_
ervils948773_ervils
etoile6312263_etoile
exertive1839083exertive
exile126117653_e_xile
exsertile1644593exsertile
facile112514883f_acile
faerie93514683faer_i_e
farcie114816473farci_e
farle86929243far__le
farside1138603farside
farting114120753farting
fartlek1434493fart_lek
fattily13379463fattily
feasible1376093feasible
featlier1136453featlier
featly123711753feat_ly
feature1039853feature
feeble1138253fe_eble
feirie939553feiri_e
feistily1445263feistily
feline94820143fe_line
felsite1039083felsite
felting113515213felting
feltlike1534983feltlike
female11310553fe_male
fenagle11197153fenagle
fencible1545603fencible
feral85424653fer_al_
ferals94216643fer_als
fere76342233fer___e
feria85922713fer_i_a
ferial94621253fer_ial
ferias95020393fer_ias
ferities111416713ferities
ferity122813343fer_ity
ferlies103216693ferlies
ferly115517353fer__ly
fermate122813003fermate
fermi103914163fermi__
fermion1236763fermion
fermis114313503fermi_s
fermium1446353fermium
fernier103110813fernier
fernlike1535243fernlike
ferrate103014033ferrate
ferrel92810203ferrel_
ferreled1234833ferreled
ferrels10248623ferrels
ferriage1245463ferriage
ferric1139993ferri_c
ferried113411523ferried
ferries103521083ferries
ferrites112312823ferrites
ferruled1263923ferruled
ferrules1136163ferrules
fertility1547203fertility
fertilized2346513fertilized
fertilizer2245313fertilizer
fertilizes2247333fertilizes
ferula93011173fer_ula
ferulae10309603ferulae
feruled11318413fer_uled
ferules103112723fer_ules
fervid1337513fervi_d
fervidly1863313fervidly
festal94213563festal_
fetal85623373fe_tal_
fete75734923fe_t__e
fetial95716193fe_tial
fetiales11319613fe_tiales
fetials103711743fe_tials
fetich1479693fe_tich
fetid93715983fe_ti_d
fetidly1435013fe_tidly
feting104417793fe_ting
fetish12310373fe_tish
fetting113517873fetting
fettled11378933fe_ttled
fettles103912733fe_ttles
fewtrils1443203fewtrils
fictive1537023fictive
fierily1339023fier_ily
file75446643f___ile
fissile10269653fissile
flexile1735073flexile
flextime2042813flextime
footie94718133footi_e
footle93914383foot_le
forcible1545143forcible
foretime1348213foretime
forgive1436193forgive
forte86131463fort__e
forties104323863forties
fortify1636523fortify
fortis95418613forti_s
fortune1068303fortune
fragile1147843fragile
frail85220213f_rail_
frailer10319943f_railer
frails93716473f_rails
fraise94214913f_raise
freckle16106643freckle
frill84917563f_r_ill
frise85322453f_r_ise
furrily1337603furrily
fusile94313493f_usile
fustily133111373fustily
gentil74115123gentil_
gentiles93713523gentiles
gentle74014513gent_le
gerbil938343gerbil_
gerbille1144613gerbille
gerbils1037303gerbils
heartily1436563heartily
heftily1635763heftily
herniae1039043herniae
heroine103517483heroine
heroize193210963heroize
hostile10312553hostile
hurtle93512943hurt_le
inertiae8411473inertiae
inutile739883inutile
jerkily2134623jerkily
kernite1159473kernite
kettle104311613ke_ttle
kirtle10309473kirt_le
laetrile845193laetrile
lentil64315393lentil_
lentils73912973lentils
meatily12311093meatily
merle75824373mer__le
merrily1238633merrily
mettle83815723me_ttle
mortice11711493mortice
mortise9713533mortise
motile83818343_motile
myrtle1135733myrt_le
nargile847653nargile
nervily1336863nervily
nervine102510623nervine
nervule1044943nervule
nestle63013953nest_le
nettle64514583ne_ttle
nitrile73011373nitrile
overtime131312273overtime
overtire111413113overtire
pantile93918483pantile
partible1238063partible
particle1239533particle
partite9317133partite
pectize20259913pectize
penile82219603pe_nile
pensile92713543pensile
peptide122910683peptide
peptize20279483peptize
percale11314083percale
perdie94718513perdi_e
peril75425953per_il_
periled10316293per_iled
perils84121853per_ils
perkily1637803perkily
perlite9317313perlite
pertly115312543pert_ly
pestle83215843pest_le
petiole9311303pe_tiole
petite84320653pe_tite
petrale9312623petrale
pettily1238173pettily
pettle84116053pe_ttle
prefile123413183prefile
puerile9310093puer_ile
quartile1747043quartile
refile95122373re_file
reptiles103913063reptiles
reraise7316313reraise
rerise64325633rer_ise
resile64627673re_sile
restive10315933restive
restyle1038763restyle
reticle94112623re_ticle
retie55735303re_ti_e
retiled84420513re_tiled
retiles74426993re_tiles
retime85321803re_time
retine66237333re_tine
retire64927013re_tire
retitle73913093re_title
revile94921613re_vile
rile45650533__r_ile
rutile65217683_rutile
sedile73517233se_dile
senile63420213se_nile
septime1138783septime
serail64222673serail_
serails73318363serails
serine65432673ser_ine
serotine8313563serotine
service1239083service
sessile739523sessile
sestine73017923sestine
settle63915663se_ttle
sextiles1537643sextiles
sortie63621983sorti_e
sterile7316603ster_ile
stile54931573__stile
subtile91912613subtile
surtitle845283surtitle
tactile9310613tactile
tartily103511573tartily
teatime9310083teatime
tectite9310583tectite
tektite1136883tektite
tensile72612733tensile
tentie62521183tenti_e
tergite8311003tergite
termite9313893termite
termtime1244773termtime
terrible1046643terrible
terrine72517573terrine
tertial7313853tertial
tertials8510073tertials
tertian7511193tertian
testicle1037443testicle
testily102910803testily
textiles1536833textiles
tile45451443___tile
turtle63213573turt_le
utile54718933__utile
verbiles1338913verbiles
verily122616053ver_ily
verite94323443ver_ite
vernicle1346433vernicle
versatile1245163versatile
versicle1366583versicle
versine102515173versine
vertices13612273vertices
vertigo1146133vertigo
vestige1137433vestige
virile9313433vir_ile
wartime1237743wartime
wergild1234043wergild
zestily19167563zestily

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.1401276364.3
2DLD Change Limit1340273227.37618170.7
3Display Results3223220.1262555.6
 (SQL Overall)1786913227.64223382.8
 
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.