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

122 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
unviable133870(None) 
enviable1337851enviable
inviable1338521inviable
enviably1645352enviably
inviably1646892inviably
leviable1337512leviable
nonviable1446262nonviable
obviable1543862obviable
unable83819222un__able
unamiable1348472unamiable
undoable1139052undoable
unenviable1545852unenviable
unhirable1447642unhirable
unifiable1447342unifiable
unlikable1546772unlikable
unlivable1447602unlivable
unmixable2045862unmixable
unpliable1347812unpliable
unridable1248292unridable
unstable10313762unstable
unusable1038952unusable
viable111613772__viable
advisable1544573advisable
alliable1038433alliable
amiable11312033_amiable
deniable11312083deniable
devisable1546853devisable
dividable1645003dividable
drivable1438023drivable
dutiable1137373dutiable
enable83318483en__able
enunciable1444313enunciable
evitable1339323_evitable
expiable1946113expiable
friable122612563_friable
fungible1444173fungi_ble
giveable14155753giveable
gnawable1435683gnawable
huntable1338093hun_table
inarable10313133inarable
incitable13310433incitable
inevitable1557643inevitable
instable10313203instable
invariable1546843invariable
inviolable1545273inviolable
invirile1145813invirile
invisible1446073invisible
knowable1745043knowable
liable81415813__liable
livable122010323liv_able
liveable13177663liveable
lovable12179553lov_able
loveable13187903loveable
movable14189433mov_able
moveable15168013moveable
munchable1844943munchable
namable11312343_namable
navigable1544743navigable
nibble103713283_n_ibble
nimble103412943_n_imble
nonliable1147673nonliable
notable92114903_notable
pitiable1238293pitiable
pliable111610323_pliable
previable1647533previable
radiable11611303radiable
reliable10313073reliable
revisable1437993revisable
revivable1736863revivable
satiable10310733satiable
savable121711863sav_able
saveable1339003saveable
skiable1338883_skiable
sociable1239503sociable
sulliable1145913sulliable
survivable1842953survivable
triable92515393_triable
tunable92511313tun__able
tuneable1038913tun_eable
unactable13310053unactable
unavailable1654683unavailable
unavoidable1753763unavoidable
unbale83616403un_ba_le
uncapable1547783uncapable
unciae83215313uncia__e
uncial83715223uncia_l_
uncially1339073uncially
uncials92510523uncia_ls
uncurable13710073uncurable
undatable1238983undatable
undeniable1348563undeniable
undouble1145443undouble
uneatable11311693uneatable
unedible1146413unedible
unfindable1644863unfindable
unflyable1744633unflyable
univalve1443473univalve
unlovable1446363unlovable
unmingle1145913unmingle
unmovable1645963unmovable
unnamable1356623unnamable
unpile81914323unpi__le
unreliable1248483unreliable
unriddle1043983unriddle
unsalable1148993unsalable
unsayable1447223unsayable
unseeable1149453unseeable
unsinkable1645093unsinkable
unsociable1447283unsociable
unstabler1145623unstabler
unstably1339493unstably
unsuitable1247573unsuitable
untamable1347843untamable
untenable11410503untenable
untillable1245983untillable
untunable1147833untunable
unwinnable1544093unwinnable
usable84012553u__sable
useable9911063u_seable
variable13310063variable
viably14199833__viably
vitiable1337503vitiable

Search took 8 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 Limit1461621227.15620425.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.65523343.0
 
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.