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 “stable” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
stable8392164(None) 
sable74732161s_able
stabile9312061stabile
stabled103514951stabled
stabler94014931stabler
stables93219071stables
stably113314121stably
stale55637101sta_le
staple84415821staple
suable83920551suable
table75429601_table
able66340532__able
actable11313472actable
arable81821002arable
bitable11312202bitable
cable95329912_cable
castable121613972castable
citable11313462citable
datable101714232datable
doable93115242doable
dyable12308982dyable
eatable91717602eatable
enable83318482enable
fable105824752_fable
gable85325522_gable
getable101712552getable
gustable11138202gustable
hatable121713962hatable
instable10313202instable
liable81415812liable
listable10810312listable
mutable11312302mutable
nestable101613672nestable
notable92114902notable
potable112115362potable
ratable91717552ratable
restable101618442restable
retable91820402retable
rustable101511362rustable
sabe66140572s_ab_e
sables85026692s_ables
sabre74821502s_abre
salable91415462salable
sale44959702s_a_le
satiable10310732satiable
savable121711862savable
sayable121411612sayable
scabble13168652scabble
scale74629142sca_le
seeable91113942seeable
sewable121911172sewable
shale85332832sha_le
shamble14149262shamble
sizable1839892sizable
skiable1338882skiable
sortable10312482sortable
sowable121610752sowable
spale74929212spa_le
stab67329932stab__
stabbed123510372stabbed
stabber113610152stabber
stabiles10311402stabiles
stablers103611152stablers
stablest103312942stablest
stabs76221382stab_s
stacte82113912stacte
staddle9288092staddle
stade64825302sta_de
stage65330192sta_ge
stake95927532sta_ke
staled74728102sta_led
staler64025822sta_ler
stales65538292sta_les
stalk94518002sta_lk
stall54722352sta_ll
stalled83515682stalled
stalls64019932stalls
stance84316912stance
stane55933002sta_ne
stapled103613702stapled
stapler93913632stapler
staples93617212staples
stare54440262sta_re
starlet71620122starlet
startle72511122startle
starve94613742starve
statable10310702statable
state56237332sta_te
statue66015322statue
stave85324992sta_ve
stele55026842st_ele
stewable1337132stewable
stifle93611902stifle
stile54931572st_ile
stole54928812st_ole
stonable1039842stonable
storable10310732storable
stowable1337612stowable
stubble1136842stubble
stumble1147552stumble
style85519362st_yle
suably112814532suably
suitable10310892suitable
swale85221592swa_le
tabla73318362_tabla
tabled94020042_tabled
tables84524892_tables
tablet84227642_tablet
tale46154162_ta_le
tastable101511972tastable
testable101412622testable
totable92313362totable
unable83819222unable
unstable10313762unstable
usable84012552usable
useable9911062useable
viable111613772viable
votable122111372votable
wastable131410452wastable

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511192.62631436.0
3Display Results1191190.0303966.7
 (SQL Overall)1786911192.99959583.5
 
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.