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

138 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
ennuye97375(None) 
ennuyee1084151ennuyee
endue64215352endu_e
endure74014142endure
ennui537522ennu_i
ennuis636472ennuis
ensue54013832ensu_e
ensure63416002ensure
enure53520222e_nure
annexe1337813annexe
annoy869713annoy_
annoyed1185873annoyed
annoyer1095603annoyer
annoys967523annoys
annual64710703annual
annul55813383annu_l
annulet7311593annulet
annuli6459053annuli
annuls64711733annuls
benne76521123benn__e
benny105217363benn_y_
censure92310603censure
dengue838253dengu_e
denture8311893denture
denude8169353denude
educe84313453e_duce
effuse1234963effuse
elude64517623e_lude
elute54822573e_lute
emeute838533emeute
enable83318483enable
enate54428153e_nate
encage93713503encage
encase83714363encase
encode9310443encode
encore8314773encore
endite73817593endite
endive103310473endive
endnote855743endnote
endued83910373endued
endues73813903endues
endured93611213endured
endurer83210363endurer
endures83314603endures
enduro7338623enduro
enemy1059993enemy_
enface112510353enface
engage82812103engage
engine71114863engine
engulf1038883engulf
enisle63412093enisle
enjoy1545963enjoy_
enjoyed1834523enjoyed
enjoyer1744383enjoyer
enjoys1644603enjoys
enlace82213233enlace
ennead736253ennead
ennoble935633ennoble
enough1045763enough
enounce937573enounce
enquire16287213enquire
enrage72715073enrage
enrobe86610793enrobe
ensile62616473ensile
ensky1235093ensky_
enskyed1532503enskyed
ensnare767123ensnare
ensued73610483ensued
ensues63313813ensues
ensured83512943ensured
ensurer73011903ensurer
ensures73315903ensures
enthuse1046963enthuse
entice81316863entice
entire61617703entire
entree61817883entree
entry82414263entry_
enuf7323843e_nu_f
enured73315333e_nured
enures63919713e_nures
envoy1156723envoy_
envoys1255143envoys
envy10411253e_nvy_
enzym1964393e_nzym
enzyme2054343enzyme
erne46727433ern__e
esne47018793esn__e
etude63612303e_tude
eunuch1154363eunuch
excuse1537423excuse
exhume1833803exhume
exude134010293e_xude
eye65539773e___ye
eyne76322463eyn__e
fenny115115133fenn_y_
inbye10427063_inbye
incuse83513573incuse
induce93811533induce
indue63516673indu_e
infuse93110573infuse
inhume1196583inhume
injure133410863injure
innage73011573innage
innate63917313innate
insure63416603insure
inure54119053_inure
jenny153811623jenn_y_
lunule638433lunule
manure8313653manure
minute83414293minute
nebule848753nebule
nene45932063nen__e
neume74414403_neume
nonuse63212253nonuse
nude56626273__nude
nuke85920753__nuke
pennae84314033penn_ae
penname11328553penname
pennate93314033pennate
penne75423853penn__e
pennine93712953pennine
penny105119453penn_y_
pinnule936003pinnule
rennase738713rennase
snye77115493_sn_ye
tenure6311613tenure
uncute82912133uncute
undue66715553undu_e
unpure82911533unpure
unsure62815413unsure
untune62511603untune
veinule1056243veinule
vendue10419013vendu_e
venture10311173venture
venue84918213venu_e
venule94411763venule
wenny114412463wenn_y_
zonule1577483zonule

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161385.72019705.6
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.15629027.1
 
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.