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

254 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
subtile9191262(None) 
subfile122010501subfile
subtiler10208571subtiler
subtitle1046601subtitle
subtle82113431subt_le
ductile1048482ductile
futile93914952fu_tile
jubile152910262jub_ile
nubile83212712nub_ile
rutile65217682ru_tile
sectile9311972sectile
sextile1438572sextile
stile54931572s__tile
subfiles131710722subfiles
sublime11310362sublime
subline9316892subline
subrule939642subrule
subsale9310542subsale
subside10410452subside
subsite9412872subsite
subtilely1444952subtilely
subtilest1148812subtilest
subtilin1047122subtilin
subtilize2087132subtilize
subtilty1345452subtilty
subtitled1244712subtitled
subtitles1156852subtitles
subtler92910842subt_ler
subtly11249262subt_ly
subtone9310342subtone
subtribe1246462subtribe
subtype1444202subtype
surtitle845282surtitle
utile54718932_u_tile
audile73315303au_dile
auntie64317703aunti_e
bastile9313913bastile
bile66147183__b_ile
bubale104014623bub_ale
bubble94016593bub_ble
bustle84015483bust_le
butle75023103bu_t_le
centile94217183centile
cubicle1337003cubicle
cuittle946403cuittle
cuticle1138233cu_ticle
cutie76925933cu_ti_e
cuttle84113893cu_ttle
ductule1065503ductule
dustily113211523dustily
eustele738193eustele
febrile1237153febrile
fertile10311733fertile
fictile1238023fictile
furtive1337173furtive
fusile94313493fu_sile
fustily133111373fustily
gentile83515293gentile
guile64521133gu__ile
gustily113010903gustily
guttle74111973gu_ttle
habile11515213hab_ile
hostile10312553hostile
hurtle93512943hurt_le
hustle93113993hust_le
inutile739883inutile
jubilee16298293jub_ilee
jubiles16289373jub_iles
justice1637423justice
justle133211583just_le
labile8315223lab_ile
lustily103611243lustily
mobile103613543mob_ile
motile83818343_motile
multiple12118303multiple
mustily123613633mustily
mutine84420373mu_tine
mutule8311423mu_tule
nubble103813713nub_ble
nuttily10308633nuttily
outlie62419533ou_tlie
outwile10310263outwile
pantile93918483pantile
puerile9310093puerile
pustule937683pustule
puttie84116303putti_e
quantile1747323quantile
quartile1747043quartile
quintile1736843quintile
reptile93914083reptile
retile65929673_retile
rubble104315673rub_ble
ruble74521253rub__le
rustily103112993rustily
rustle63615413rust_le
rutiles74315843ru_tiles
ruttily10338613ruttily
sabine84020393sab_ine
sable74732163sab__le
saltie63422433salti_e
saltily10310543saltily
saltine75018563saltine
saltire73113043saltire
satire63218003s_atire
saxatile1544953saxatile
scurrile1055073scurrile
scuttle936463scuttle
sedile73517233s_edile
senile63420213s_enile
septime1138803septime
servile10310643servile
sessile739523sessile
sestine73017923sestine
settle63915663s_ettle
sextiles1537643sextiles
shuttle1046103shuttle
simile83115633s_imile
skatole1135693skatole
skittle1135533skittle
smile74823923s__mile
smuttily1344273smuttily
softie93312483softi_e
sootily101810523sootily
sortie63621993sorti_e
soubise9118793soub_ise
spatzle1834583spatzle
spile75230083s__pile
spittle937923spittle
spurtle937453spurt_le
stabile9312063stabile
stale55637103s__tale
statice92614033statice
stative102612933stative
stele55026843s__tele
sterile7316603sterile
stifle93611903s__tifle
stiles64328773s__tiles
still54922083s__till
stilt54831983s__tilt
stime76521803s__time
stipe76523373s__tipe
stole54928813s__tole
stubbily1564243stubbily
stubble1136843stub_ble
style85519363s__tyle
suable83920553su_able
suasive1037853suasive
subbase1139323subbase
subbing123915583subbing
subcell1146753subcell
subcode1237163subcode
subcult1149603subcult
subduce12106983subduce
subdue9128493sub_due
suberise10813933suberise
suberize19812153suberize
subfield1444753subfield
subfix1835073subfi_x
subfixes20207493subfixes
subidea1037533sub_idea
subitem1138553subitem
subito8410453sub_ito
sublate9315363sublate
sublet82827243sub__let
sublimed1337213sublimed
sublimer1237613sublimer
sublimes12310033sublimes
sublines10315783sublines
submiss1138083submiss
submit10312673submi_t
submits1139753submits
subniche1554253subniche
suboxide1845213suboxide
subrace11313003subrace
subring104116263subring
subrules1039723subrules
subsales10310123subsales
subscale1247603subscale
subsere9311443subsere
subsided1257663subsided
subsider1138243subsider
subsides11410823subsides
subsidy1345973subsidy
subsist9311573subsist
subsites10312783subsites
subskill1444233subskill
subsoil967293subsoil_
subsoiled1245453subsoiled
subsoiler1145323subsoiler
subsoils1076653subsoils
substage11117183substage
substate101711093substate
subsume1146713subsume
subtask1335713subtask
subtaxa1644483subtaxa
subteen938523subteen
subtend1037103subtend
subtest9513963subtest
subtext1647653subtext
subtheme1544333subtheme
subtilins1147173subtilins
subtility1446603subtility
subtilized2246143subtilized
subtilizes2166873subtilizes
subtilties1246113subtilties
subtlest10511363subt_lest
subtlety1345063subt_lety
subtones10311383subtones
subtribes1346233subtribes
subtypes1544553subtypes
subvene1238493subvene
subzone1846993subzone
suckle124015963su_ckle
suction93713043suction
suffice15197573suffice
suicide1038893suicide
suitable10310893suitable
suite54829563su__ite
suiting83419003suiting
suitlike1236313suitlike
sulfide1138103sulfide
sulfite10310473sulfite
sulkily14218113sulkily
sultrily1146493sultrily
sunlike112310573sunlike
sunnily1037833sunnily
sunrise7310813sunrise
sunwise1036433sunwise
supine84216693su_pine
supple10410203su_pple
surlily10310003surlily
surmise9311083surmise
surtitles945633surtitles
survive1335933survive
suspire937803suspire
sutler63718393su_t_ler
suttee63721543su_ttee
suture6313203su_ture
systole1035763systole
tactile9310613tactile
textile1437223textile
tile45451443___tile
tortile7313193tortile
tublike1337083tublike
tubule839853tub_ule
tuftily1335573tuftily
turtle63213573turt_le
unpile81914323_unpile
unsubtle1043873unsubt_le
untie54425493_unti_e
until53517743_until_
uppile10178503_uppile
uptilt8410803_uptilt
uptime1067673_uptime

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272545.87622809.2
3Display Results2542540.0932731.2
 (SQL Overall)1786912546.35928100.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.