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

218 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
instable1031320(None) 
unstable10313761unstable
castable121613972castable
constable13311002constable
gustable11138202gustable
ignitable1245462ignitable
imitable1239122imitable
inarable10313132inarable
incitable13310432incitable
insatiable12107762insatiable
instal6712192insta_l_
install779362insta_ll
installed1045852installed
installer945012installer
installs858922installs
instals7611712insta_ls
instance1049882instance
instate71616482insta_te
insurable111011092insurable
investable1548042investable
inviable1338522inviable
issuable1046872issuable
listable10810312listable
nestable101613672nestable
notable92114902_notable
restable101618442restable
rinsable10310042rins_able
rustable101511362rustable
stable83921642__stable
tastable101511972tastable
testable101412622testable
unstabler1145622unstabler
unstably1339492unstably
wastable131410452wastable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
beatable121612243beatable
bindable13169623bin_dable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
citable11313463_citable
constables1446733constables
cuttable1247953cuttable
datable101714233_datable
denotable1238373denotable
dilatable1246853dilatable
disable10516433dis_able
eatable91717603_eatable
editable11310423editable
enable83318483en__able
enactable1338493enactable
ensemble1244973ensemble
enviable1337853enviable
evitable1339323evitable
fightable1844373fightable
finable122213623fin__able
findable14179023fin_dable
fineable131810333fin_eable
fishable1637593fishable
fittable1337093fittable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
gnawable1435683gnawable
gustables12165223gustables
hatable121713963_hatable
heatable131612043heatable
hittable1336853hittable
huntable1338093huntable
ignitible1243163ignitible
ignorable1245333ignorable
immutable1545593immutable
imputable1546683imputable
incapable1547573incapable
incunable13108743incunable
incurable131010773incurable
indexable1947033indexable
indictable1547493indictable
inedible1147473inedible
ineffable17105793ineffable
inerrable11410163inerrable
inestimable1555793inestimable
inevitable1557643inevitable
inferable14411273inferable
inflatable1546003inflatable
ingestible1346333ingestible
inhale9411523in_ha_le
inimitable1446533inimitable
injectable2147003injectable
injurable18117413injurable
insane6314893ins_a_ne
insatiably15106693insatiably
inscape1138023insca_pe
inscrutable1554673inscrutable
insnare748243insna_re
insociable1447713insociable
insole63515863ins__ole
insoluble1144243insoluble
insolvable1545363insolvable
installers1043633installers
instanced1245703instanced
instances1148753instances
instancy1346573instancy
instant7815353insta_nt
instanter946243instanter
instantly1256013instantly
instants8910153instants
instar6310013insta__r
instarred1043963instarred
instars7411133insta_rs
instated91613343instated
instates81615833instates
instil61111383inst_il_
instill789063inst_ill
instilled1045303instilled
instiller944953instiller
instills867353instills
instils7811453inst_ils
instroke1245583instroke
inswathe1443693inswathe
intagli845023in_tagli
intake10510863in_ta_ke
intitle7610583in_title
intuitable1247103intuitable
inutile739883inut_ile
inviably1646893inviably
ionizable2045513ionizable
irritable1148053irritable
isolable1038793isolable
issuably1344963issuably
istle52214713i_st__le
kissable1436853kissable
knittable1544243knittable
knowable1745043knowable
liftable1376863liftable
limitable1345643limitable
linable92214343lin__able
lineable101811083lin_eable
linkable14187263lin_kable
losable91910953los_able
maskable1638003maskable
meltable12310473meltable
minable112315073min__able
mineable121611053min_eable
missable12311533missable
mutable11312303_mutable
namable11312343_namable
nettable101610243nettable
nonstaple1144923nonstaple
notables10178243_notables
notably12199993_notably
obstacle1243593obstacle
onstage838363onsta_ge
paintable1337243pain_table
passable12310633passable
pettable121710713pettable
pivotable1644563pivotable
pointable1337343poin_table
portable12313203portable
posable112212783pos_able
potable112115363_potable
printable1338203prin_table
quotable1936493quotable
ratable91717553_ratable
rentable101716333rentable
restabled12148963restabled
restables111511423restables
retable91820403_retable
rinsible1046293rins_ible
sable74732163__s_able
singable11159543sin_gable
sinkable14178413sin_kable
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stale55637103__sta_le
staple84415823__staple
statable10310703statable
suable83920553__suable
suitable10310893suitable
table75429603___table
tasteable1146123tasteable
tiltable10159013tiltable
timetable1346873timetable
totable92313363_totable
trustable1147123trustable
twistable1444273twistable
unable83819223un__able
unactable13310053unactable
undatable1238983undatable
undoable1139053undoable
uneatable11311693uneatable
unsalable1148993unsalable
unsayable1447223unsayable
unseeable1149453unseeable
unstablest1244183unstablest
unstate71916213unsta_te
unsuitable1247573unsuitable
untestable1248823untestable
unusable1038953unusable
unviable1338703unviable
usable84012553_us_able
useable9911063_useable
visitable1445873visitable
votable122111373_votable
washable16138043washable
wettable13148043wettable
windable14159153win_dable
winnable13156983win_nable
writable1338753writable

Search took 9 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.826216332.9
2DLD Change Limit1461622187.47019566.5
3Display Results2182180.0932344.1
 (SQL Overall)1786912188.38921300.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.