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

422 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
tubist8301316(None) 
cubist104214441cubist
tubaist938701tubaist
tubists9288321tubists
aurist65027252aurist
autist64324942autist
cubism12348702cubism
cubists11359022cubists
cubit94122892cubi_t
cubits103714032cubits
jurist134616392jurist
lutist64317552lutist
nudist73813322nudist
pubis94616472pubis_
purist85525052purist
qubit164218992qubi_t
qubits173710352qubits
rubiest92914422rubiest
subsist9311572subsist
tanist6324592tanist
theist9314762theist
tourist7313202tourist
tubaists1055102tubaists
tubas75119582tubas_
tubbiest12117292tubbiest
tubes74826452tubes_
tubing93813092tubing
tubs65430062tub_s_
tuis44829642tu_is_
turbit8715112turbi_t
turbits969232turbits
turista737442turista
twist86820982t_wist
typist1139822typist
vibist11610582vibist
ageist7315383ageist
agist66325583_agist
alist56136783_alist
ambit94223713ambi_t
ambits103713413ambits
aorist64827873aorist
artist64125543artist
assist6314603assist
atavist10311093atavist
atheist10314063atheist
atomist92915763atomist
audit62527883audi_t
audits72814113audits
august739203august
auris55331533auris_
aurists74615783aurists
autism83815333autism
autists73814853autists
babiest114414753babiest
bast66362413__bast
bemist105216953bemist
best66355323__best
biblist11310833biblist
bint67355043__bint
bis56860663__bis_
bise66437103__bise
bisk106523353__bisk
bit57070903__bi_t
bits66148163__bits
bitt65545813__bitt
blurbist1245493blurbist
bubs86235503bub_s_
bubus95115453bubus_
built74325923bu_ilt
bundist10310193bundist
burst75332243bu_rst
busiest93716303busiest
bust65947783__bust
cambist13312113cambist
chutist1239453chutist
cist67244963__cist
cubbish1635803cubbish
cubes95028163cubes_
cubic114313423cubi_c
cubics123810163cubics
cubing114213953cubing
cubisms13306883cubisms
cubistic1445703cubistic
cubiti10399083cubiti
cubs85832383cub_s_
cuish10313173cu_ish
cultist91412713cultist
curst74931023cu_rst
cutest85820143cutest
cutis77723763cutis_
daubiest1138233daubiest
debit85727853debi_t
debits94214503debits
deist64633593_deist
delist74625053delist
desist74818813desist
dualist8614053dualist
dubiety1344583dubiety
dubs78432193dub_s_
dudish1148313dudish
duelist8511413duelist
duit56241583du_i_t
duits65021883du_its
dumbest1238743dumbest
durst66125173du_rst
dust57142533du__st
egoist7612283egoist
enlist6417043enlist
etatist7415033etatist
etuis54013133etu_is_
exist124618943_exist
fauvist1336663fauvist
feist86230073_feist
feudist1137573feudist
fist76248423__fist
flutist102910783flutist
foist85730973_foist
fubs96328793fub_s_
fubsiest13258413fubsiest
fubsy13589273fub_sy
fuguist1136073fuguist
fujis15379243fujis_
fumiest12312193fumiest
funest94316863funest
furbish1536443furbish
futurist1148283futurist
gist56046763__gist
grist65529873_grist
guest65225923gu_est
guilt65125573gu_ilt
guise64717713gu_ise
gust55240703gu__st
habit103027023habi_t
habits113014653habits
heist87030913_heist
hist76551543__hist
hoist86433213_hoist
holist94723213holist
hubris11218973hubris_
hubs96027143hub_s_
hugest10311763hugest
hurst85527193hu_rst
ibis66519583_ibis_
insist6314513insist
joist125125653_joist
jubas144614223jubas_
jubes145420743jubes_
jubile152910263jubile
judoist1545633judoist
jujuist1343073jujuist
jurists14409123jurists
just115433343ju__st
kist86540793__kist
krubis1235003krubis_
kufis1249253kufis_
kumiss1235923kumiss
legist71315253legist
list47055343__list
lubes74727993lubes_
lubing94114043lubing
luniest73516993luniest
lust47442603lu__st
lutists73810273lutists
lyrist9312293lyrist
maist75535683_maist
mist66154533__mist
moist76033583_moist
monist84324983monist
mulish11311903mulish
munis75022003munis_
must65145443mu__st
mutest84218053mutest
mutism103211463mutism
nabis76020583nabis_
naturist8410813naturist
neist54628443_neist
nubbiest12117313nubbiest
nubia7311233nubi_a
nubias8310093nubias
nubile83212713nubile
nubs65927143nub_s_
nudest74113833nudest
nudism9357913nudism
nudists8356833nudists
numbest1138793numbest
obis66226843_obis_
obit66837083_obi_t
obits74617553_obits
oboist8312683oboist
oculist9310883oculist
odist6421913_odist
orbiest9312413orbiest
orbit73622063orbi_t
orbits84211443orbits
oust46747443ou__st
outsit63620893outsit
papist102618743papist
pubes94423403pubes_
pubic114513723pubi_c
publish1447913publish
pubs85029213pub_s_
pulis74225603pulis_
puniest92918093puniest
punish111411503punish
purest84021933purest
puris75332023puris_
purism104715063purism
purists94014073purists
quaint15415173quaint
quais144618393quais_
querist16311133querist
quest144121323qu_est
quiet144530733qu_iet
quilt144125103qu_ilt
quint144529903qu_int
quirt144624233qu_irt
quit136136513qu_i_t
quits144122353qu_its
quoit143819863quoi_t
quoits15379683quoits
racist82822793racist
rapist82520673rapist
relist64628413relist
resist64524533resist
robust8310433robust
rubbish1436303rubbish
rubes74928413rubes_
rubied94312413rubied
rubier84814743rubier
rubies84420343rubies
rubigo935053rubigo
rubout8313563rubout
rubs66133493rub_s_
rubus76415063rubus_
rudest74016313rudest
ruliest72816433ruliest
rust45544913ru__st
sadist74221353sadist
schist11312653schist
sexist133013483sexist
shist84829613_shist
soubise9118793soubise
statist7317723statist
stubbiest1345483stubbiest
stubs75016073stub_s_
stylist102110283stylist
subas74724073subas_
subito8410453subito
sublet82827243sublet
sublot82315523sublot
submiss1138083submiss
submit10312673submit
submits1139753submits
subnet82520933subnet
subs66037123sub_s_
subset83122583subset
subsists1037993subsists
subsite9412873subsite
subtest9513963subtest
suint55638183su_int
suit45649873su_i_t
suits55028053su_its
sumoist9311613sumoist
surest65026763surest
tabbis102910863tabbis_
tabes76033923tabes_
tabid84418263tabi_d
tablet84227643tablet
tabs66842983tab_s_
tabus74820923tabus_
tachist12613293tachist
tacit76333673taci_t
taint55542283t_aint
tamest85721293tamest
tamis76728733tamis_
tanists7313653tanists
tapis75028863tapis_
tautest72612443tautest
taxis126821973taxis_
tennist72813113tennist
test48651623t__est
theism1139483theism
theists1039153theists
thirst9312253thirst
this76027383t_his_
thrift12412043thrift
thrust91911893thrust
tibia7312403tibi_a
tibiae838483tibiae
tibial849843tibial
tibias839953tibias
tidbit938493tidbi_t
tidbits1035183tidbits
tidiest83514873tidiest
tikis95615973tikis_
tilt46252423t__ilt
tiniest73020123tiniest
tint46758863t__int
tipis76019923tipis_
tis37056643t__is_
tit36771053t__i_t
titbit839823titbi_t
titbits935803titbits
titis56023813titis_
titlist7312923titlist
tits46145043t__its
toast55831013t_oast
tobies84521023tobies
toit46353063t_oi_t
toits55327473t_oits
toniest73218903toniest
tonish93415903tonish
topis76025833topis_
tost48351923t__ost
tourism939423tourism
tourista844403tourista
tourists838313tourists
touristy1144513touristy
toyish122911123toyish
trait56940843trai_t
traits65121983traits
triste63818643t_riste
trois57226093trois_
truest64816193truest
truism8118623truism
trust55426853t_rust
tryst84716223t_ryst
tsarist7712253tsarist
tsuris62710203tsuris_
tub55640033tub___
tuba65422363tub__a
tubae74716643tub_ae
tubal75517203tub_al
tubate82813173tubate
tubbed114712223tubbed
tubber104313203tubber
tubbier11237743tubbier
tubbing123510093tubbing
tubby124511403tub_by
tube65828663tub__e
tubed85818043tub_ed
tuber75420683tub_er
tubers85017033tubers
tubful1136683tubful
tubifex1942063tubifex
tubings10336483tubings
tublike1337083tublike
tubule839853tubule
tucket124219483tucket
tucks114721123tucks_
tufas85314383tufas_
tuffet122612083tuffet
tuffs115118263tuffs_
tuft76929513tu__ft
tuftiest1138283tuftiest
tufts85713273tufts_
tugboat10126103tugboat
tugs56231673tu_gs_
tui37034023tu_i__
tules54532793tules_
tulip71111693tuli_p
tulips8137253tulips
tumid84114023tumi_d
tumps95420793tumps_
tumult839703tumult
tunas54224123tunas_
tundish1137283tundish
tunes55332193tunes_
tungs65520623tungs_
tunic74018223tuni_c
tunica8379813tunica
tunics83811263tunics
tuning74016843tuning
tuns45138663tu_ns_
tupik1149003tupi_k
tupiks1235493tupiks
tups65628763tu_ps_
turbid979713turbi_d
turbine9310303turbine
turbith1267113turbith
turbos8910783turbos_
turbot8914263turbot
turbots988023turbots
turds65021693turds_
turfiest112410133turfiest
turfs84620443turfs_
turion6313163turion
turistas846693turistas
turks95320823turks_
turns55623233turns_
turps74918733turps_
turret63121853turret
tush74523903tu__sh
tusk85621633tu__sk
tusks94915533tusks_
tussis6379953tussis
tut36758093tu___t
tuts45838453tu_ts_
tuttis63611373tuttis_
tutus55214813tutus_
tuxes124316043tuxes_
twists9549753t_wists
twisty12426863t_wisty
twit76329063t_wi_t
twits86015793t_wits
twixt155512483t_wixt
typiest1238203typiest
typists1236173typists
tzarist1659103tzarist
tzuris15286913tzuris_
ubiety1135913_ubiety
unit45140073_uni_t
units54923433_units
utmost878483utmost
utopist938693utopist
verist93823893verist
vibists1256483vibists
waist86132383_waist
whist115322953_whist
wist78049293__wist
wrist84827563_wrist
wurst85122993wu_rst

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127164225.10622075.2
3Display Results4224220.1432951.0
 (SQL Overall)1786914225.39233140.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.