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

156 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
jezails233416(None) 
jezail2234641jezail_
bewails1277552bewails
bezils1711310602bez_ils
derails84216392derails
details84214042details
emails84412342_emails
jails125422942j__ails
remails94714562remails
renails74917262renails
resails74616742resails
retails74718972retails
serails73318362serails
tenails73713922tenails
aerials74017553aerials
agnails837003agnails
ails45654713___ails
assails769093assails
avails939693_avails
bails75933523__bails
bedrails1136293bedrails
befalls12349123befalls
begalls10319163begalls
bewail1189583bewail_
bezants1877343bezants
bezels173712283bez_els
bezil163812883bez_il_
brails84621293_brails
brazils1867753brazils
camails11311753camails
ceils75019403ce__ils
deairs74013783de_airs
deals65435343de_a_ls
decals93717713deca_ls
deils65722863de__ils
denials84114133denials
dentils84115583dentils
derail74218813derail_
detail74516433detail_
detains83716093detains
devils104412813de_vils
drails74716953_drails
earls56127513_e_arls
elains64919853_elains
email74715103_email_
entails7912823entails
ervils948773_ervils
evils84114263_e_vils
fails85631483__fails
fecials123510333fecials
ferals94216643fera_ls
fetials103711743fetials
flails94313003_flails
frails93716473_frails
frazils1956123frazils
fuzils18407963fuz_ils
gerbils1037303gerbils
grails77518783_grails
hails85231643__hails
heals85733463he_a_ls
heils85222193he__ils
jacals1539873jaca_ls
jail115529093j__ail_
jarls126120963j__arls
jazzily2533373jazzily
jeans126022113je_a_ns
jebels15418913je_bels
jehads1735833jeha_ds
jellies143816533jellies
jells125522163je__lls
jemmies18318333jemmies
jennies143511623jennies
jerids142810943je_rids
jerkies183411583jerkies
jerkily2134623jerkily
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
jesuits1436323jesuits
jetfoils1842453jetfoils
jetties143613123jetties
jewels16508613je_wels
jezebels2641783jezebels
jouals1338933joua_ls
kails95525213__kails
kevils13358333ke_vils
legals73412733lega_ls
lentils73912973lentils
lezzies1536203lezzies
mails76037783__mails
meals75933383me_a_ls
medals94218063meda_ls
medials103914743medials
menials94015693menials
metals84520893meta_ls
mezcals20246543mezcals
nails55730403__nails
oxtails1436383oxtails
pails75833063__pails
peals75235493pe_a_ls
pearls84715393pe_arls
pedals94316033peda_ls
pencils113011773pencils
pensils92811593pensils
perils84121853pe_rils
petals84719813peta_ls
prevails1337663prevails
quails153412643_quails
quezals2544253queza_ls
rails55937403__rails
reals55038653re_a_ls
reavails1134853reavails
rebaits9312573rebaits
reboils94111723reboils
recalls92613623recalls
recoils93814873recoils
redials84416883redials
redtails968003redtails
refalls103312243refalls
regains84316583regains
remail85017123remail_
remains94117913remains
renail65020763renail_
reoils64516873re_oils
repairs9319973repairs
resail64418733resail_
retail65522073retail_
retains74522253retains
sails55738103__sails
seals54839703se_a_ls
sepals85217383sepa_ls
serail64222673serail_
serais64326133serai_s
serials73919753serials
snails64816653_snails
spails84817823_spails
swails94913123_swails
tails55634193__tails
teals56234133te_a_ls
teazels16406893teazels
tenail64516113tenail_
tepals85415043tepa_ls
terais64023513terai_s
toenails847213toenails
trails64622513_trails
trenails869843trenails
unnails738223unnails
vails85825933__vails
veals84926193ve_a_ls
veils84918803ve__ils
ventails1139823ventails
vexils1647173ve_xils
wails86631483__wails
weals85428743we_a_ls
weevils1384683weevils
zeals145320853ze_a_ls

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.403443402.0
2DLD Change Limit1340271566.34621119.9
3Display Results1561560.0632476.2
 (SQL Overall)1786911566.81226231.8
 
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.