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

124 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
erectile103951(None) 
erective13311831erective
ejective2037152ejective
elective13311002elective
erectable131210092erectable
erecting112415062erecting
erection102115512erection
erectly1257472erect_ly
erewhile1473672erewhile
orective1339352orective
reptile93914082_reptile
retile65929672_re_tile
sectile9311972_sectile
tractile10311072tractile
centile94217183_centile
creatine103417413creatine
creative132812803creative
decile94619213_dec_ile
defective1848003defective
detective1548103detective
directive1557773directive
ductile1048473_ductile
eductive1476853eductive
effective2076193effective
egestive1246833egestive
ejectable20136573ejectable
ejecting18268163ejecting
ejection172510043ejection
ejectives2145443ejectives
electable13149623electable
electee92513243elect_ee
electing112113783electing
election102015353election
electives1448913electives
emetine9712943eme_tine
enactive1338513enactive
erect74129333erect___
erected103213993erect_ed
erecter93113393erect_er
erecters102611613erecters
erectility1546263erectility
erections112515193erections
erector93513803erect_or
erectors103514253erectors
erects84116183erect__s
eremite9312833ere_mite
erewhiles1563173erewhiles
ergative1238973ergative
erotize16311653er_otize
eructate1047333eructate
eructing112110173eructing
eruptible1342913eruptible
eruptive1345793eruptive
evection131910833evection
eventide1246853eventide
executive2164743executive
exertive1839083exertive
exsertile1644593exsertile
fertile10311733_fertile
fictile1238023_fictile
freckle16106643frec_kle
gentile83515293_gentile
gracile102512603grac_ile
grecize1935663grec_ize
insectile1147103insectile
orectic1138823orecti_c
pectize20259913_pectize
percentile1447403percentile
perfectible2053423perfectible
perfective2047193perfective
practice1438733practice
practise12310143practise
precative16312573precative
prechill1546193prechill
precipe133012123prec_ipe
precise113518173prec_ise
prefile123413183pre_file
prentice121012353prentice
prestige11310733prestige
prettily1337273prettily
projectile2144553projectile
reactive13310473reactive
receive1239733_receive
recipe103414893_rec_ipe
recite83625113_rec_ite
recline94020493_recline
recoil84016723_recoil_
recoiled113613213_recoiled
recoiler103210493_recoiler
recoils93814873_recoils
rectal84418133_rectal_
recti73619623_recti__
rectify1536453_rectify
recycle1445343_recycle
refective1749113refective
refile95122373_re_file
refractile1544143refractile
rejective2148253rejective
reptiles103913063_reptiles
resile64627673_re_sile
restive10315933_restive
restyle1038763_restyle
reticle94112623_re_ticle
retie55735303_re_ti_e
retiled84420513_re_tiled
retiles74426993_re_tiles
retime85321803_re_time
retine66237333_re_tine
retire64927013_re_tire
retitle73913093_re_title
retractile1246253retractile
revile94921613_re_vile
rutile65217683_r_utile
selective1449523selective
sextile1438573_sextile
smectite1245773smectite
tactile9310613_tactile
tectite9310583_tectite
textile1437223_textile
tractive13310043tractive
treatise8311103treatise
trestle72611363trest_le
versatile1245163versatile
wrestle10298843wrest_le

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.1531167915.0
2DLD Change Limit1461621247.83018666.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.02922255.7
 
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.