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

135 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
enviable133785(None) 
enviably1645351enviably
inviable1338521inviable
unviable1338701unviable
deniable11312082den_iable
enable83318482en__able
evitable1339322e_vitable
expiable1946112expiable
inviably1646892inviably
leviable1337512leviable
nonviable1446262nonviable
obviable1543862obviable
unenviable1545852unenviable
viable111613772__viable
advisable1544573advisable
alliable1038433alliable
amiable11312033_amiable
bendable131510853ben_dable
deniably1448553den_iably
denotable1238373denotable
derivable1548063derivable
devisable1546853devisable
dividable1645003dividable
drivable1438023drivable
dutiable1137373dutiable
eatable91717603e_atable
edible969353e_di_ble
editable11310423editable
educable1337093educable
effable15106673e_ffable
emptiable1544843emptiable
enabled102510633en__abled
enabler9299363en__abler
enables92813123en__ables
enactable1338493enactable
encircle1243943encircle
encodable1446273encodable
endurable1247733endurable
enfeeble13103223enfeeble
engirdle1043223engirdle
enisle63412093en_i_sle
enjoyable2143743enjoyable
enkindle1363163enkindle
ennoble935633en_noble
ensemble1244973ensemble
ensile62616473ensi__le
enterable11312643enterable
entitle7610293enti_tle
enunciable1444313enunciable
envisage1242653envisage
equable1849253e_quable
equitable2046193equitable
erasable10511043erasable
erodable1139203erodable
errable9312183e_rrable
estimable1346043estimable
evadable1436363evadable
evocable1537103evocable
excisable2045053excisable
excitable2056243excitable
exilable1737203exilable
exorable1738933exorable
eyeable1239063e_yeable
fencible1545603fenci_ble
friable122612563_friable
generable1238663generable
giveable14155753giveable
gnawable1435683gnawable
inarable10313133inarable
incitable13310433incitable
inevitable1557643inevitable
instable10313203instable
invariable1546843invariable
inviolable1545273inviolable
invirile1145813invirile
invisible1446073invisible
knowable1745043knowable
lendable11169463len_dable
liable81415813__liable
livable122010323liv_able
liveable13177663liveable
lovable12179553lov_able
loveable13187903loveable
mendable131510583men_dable
movable14189433mov_able
moveable15168013moveable
namable11312343_namable
navigable1544743navigable
nestable101613673nestable
nettable101610243nettable
nibble103713283_n_ibble
nimble103412943_n_imble
nonliable1147673nonliable
notable92114903_notable
pitiable1238293pitiable
pliable111610323_pliable
previable1647533previable
radiable11611303radiable
reliable10313073reliable
relivable1438513relivable
rendible11128353rendi_ble
renewable1447433renewable
rentable101716333ren_table
revisable1437993revisable
revivable1736863revivable
satiable10310733satiable
savable121711863sav_able
saveable1339003saveable
sendable111612043sen_dable
sensible1037853sensi_ble
servable13310093serv_able
skiable1338883_skiable
sociable1239503sociable
tenable93214493ten__able
tensible1037243tensi_ble
tenurable1147423tenurable
triable92515393_triable
unable83819223un__able
unamiable1348473unamiable
undoable1139053undoable
unhirable1447643unhirable
unifiable1447343unifiable
unlikable1546773unlikable
unlivable1447603unlivable
unmixable2045863unmixable
unpliable1347813unpliable
unridable1248293unridable
unstable10313763unstable
unusable1038953unusable
variable13310063variable
vendable14159693ven_dable
vendible14156473vendi_ble
venerable1438483venerable
viably14199833__viably
vitiable1337503vitiable

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621356.22023498.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.68626726.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.