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

134 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
inviable133852(None) 
enviable1337851enviable
inviably1646891inviably
unviable1338701unviable
enviably1645352enviably
inarable10313132inarable
incitable13310432incitable
inevitable1557642inevitable
instable10313202instable
invariable1546842invariable
inviolable1545272inviolable
invirile1145812invirile
invisible1446072invisible
leviable1337512leviable
nonviable1446262nonviable
obviable1543862obviable
viable111613772__viable
advisable1544573advisable
alliable1038433alliable
amiable11312033_amiable
bindable13169623bin_dable
deniable11312083deniable
devisable1546853devisable
dividable1645003dividable
drivable1438023drivable
dutiable1137373dutiable
enable83318483en__able
evitable1339323_evitable
expiable1946113expiable
finable122213623fin__able
findable14179023fin_dable
fineable131810333fin_eable
friable122612563_friable
giveable14155753giveable
gnawable1435683gnawable
ignitable1245463ignitable
ignorable1245333ignorable
imitable1239123imitable
inadvisable1753473inadvisable
incapable1547563incapable
inclinable1447713inclinable
incunable13108743incunable
incurable131010773incurable
indexable1947033indexable
indictable1547493indictable
inedible1147473inedible
ineffable17105793ineffable
inerrable11410163inerrable
inevitably1856193inevitably
inexpiable2145653inexpiable
inferable14411273inferable
inhale9411513in_ha_le
inimitable1446533inimitable
injurable18117413injurable
insatiable12107763insatiable
insociable1447713insociable
insurable111011093insurable
intitle7610583inti_tle
intitule867423intitule
intuitable1247103intuitable
invade10157853inv_a_de
invaluable1545073invaluable
invariables1652773invariables
invariably1845673invariably
inveigle1243973inveigle
investable1548043investable
invincible1753393invincible
inviolably1853993inviolably
invisibles1543453invisibles
invisibly1745033invisibly
invital1046953invital_
invite93715033invi__te
invitee103713543invi_tee
ionizable2045513ionizable
irrigable1246233irrigable
irritable1148053irritable
isolable1038793isolable
issuable1046873issuable
knowable1745043knowable
liable81415813__liable
linable92214343lin__able
lineable101811083lin_eable
linkable14187263lin_kable
livable122010323liv_able
liveable13177663liveable
lovable12179553lov_able
loveable13187903loveable
minable112315073min__able
mineable121611053min_eable
movable14189433mov_able
moveable15168013moveable
namable11312343_namable
navigable1544743navigable
nibble103713283_n_ibble
nimble103412943_n_imble
nonliable1147673nonliable
notable92114903_notable
pitiable1238293pitiable
pliable111610323_pliable
previable1647533previable
radiable11611303radiable
reliable10313073reliable
revisable1437993revisable
revivable1736863revivable
rinsable10310043rin_sable
rinsible1046293rinsi_ble
satiable10310733satiable
savable121711863sav_able
saveable1339003saveable
singable11159543sin_gable
sinkable14178413sin_kable
skiable1338883_skiable
sociable1239503sociable
triable92515393_triable
unable83819223un__able
unamiable1348473unamiable
undoable1139053undoable
unenviable1545853unenviable
unhirable1447643unhirable
unifiable1447343unifiable
unlikable1546773unlikable
unlivable1447603unlivable
unmixable2045863unmixable
unpliable1347813unpliable
unridable1248293unridable
unstable10313763unstable
unusable1038953unusable
variable13310063variable
viably14199833__viably
vincible1544753vinci_ble
vindicable1843903vindicable
vitiable1337503vitiable
windable14159153win_dable
winnable13156983win_nable

Search took 10 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.453394461.4
2DLD Change Limit1461621348.43617326.0
3Display Results1341340.266503.8
 (SQL Overall)1786911349.15519518.4
 
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.