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

102 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
unstably133949(None) 
unstable10313761unstable
instable10313192instable
notably12199992_notably
stably113314122__stably
unsalably1446322unsalably
unstabler1145622unstabler
unsuitably1555672unsuitably
usably11288982u_s_ably
useably1287392u_seably
castable121613973castable
constable13310993constable
costally1339723costally
countably1646283coun_tably
distally1239553distally
dubitably1743753dubitably
enviably1645353enviably
festally1437543festally
gustable11138203gustable
huntable1338093hun_table
insatiably15106693insatiably
instal6712183insta_l_
install779353insta_ll
installs858923installs
instals7611713insta_ls
instancy1346563instancy
instantly1256013instantly
inviably1646893inviably
issuably1344963issuably
kissably1744073kissably
listable10810303listable
mutably1438613_mutably
nestable101613673nestable
notable92114903_notable
passably1537253passably
portably1539313portably
postally13310273postally
quotably2244153quotably
ratably121711513_ratably
restable101618433restable
rustable101511353rustable
sortably1338803sortably
stable83921643__stable
suably112814533__suably
suitably1347583suitably
tastable101511973tastable
testable101412623testable
tunably12218293tun__ably
tuneably1346093tun_eably
unable83819223un__able
unactable13310053unactable
unbeatably1745363unbeatably
uncially1339073uncially
uncurably1697793uncurably
undatable1238983undatable
undoable1139053undoable
uneatable11311693uneatable
unitarily1246023unitarily
unitary1038613unita_ry
unitedly1245793unitedly
unmanly1236993un_manly
unreally1148223unreally
unsafely1454413unsafely
unsalable1148993unsalable
unsay83212843uns_a__y
unsayable1447223unsayable
unseal63315473unsea_l_
unseals73212573unsea_ls
unseeable1149453unseeable
unseemly1343763unseemly
unshakably2253483unshakably
unshapely1742823unshapely
unsnarl7107153unsnarl_
unsnarls894883unsnarls
unsociably1745423unsociably
unstablest1244183unstablest
unstack1337373unsta_ck
unstacks1446043unstacks
unstate71916213unsta_te
unstated91615813unstated
unstates81314993unstates
unstayed12168393unstayed
unsteadily1452673unsteadily
unsteady1243513unsteady
unsteel738793unsteel_
unsteels845793unsteels
unstoppably2052023unstoppably
unstuffy1761673unstuffy
unsubtly1343093unsubtly
unsuitable1247573unsuitable
unsurely1146383unsurely
untenably1447533untenably
untestable1248823untestable
untruly1046293un_truly
unusable1038953unusable
unusually1243333unusually
unviable1338703unviable
usable84012553u_s_able
useable9911063u_seable
usually1066063u_sually
vestally1437413vestally
wastable131410453wastable

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.1731032896.0
2DLD Change Limit1461621028.29617618.4
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.51520985.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.