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

487 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
tubate8281317(None) 
tubae74716641tuba_e
abate76627842_abate
aubade939222aubade
aurate64426472aurate
bate66552422__bate
bubale104014622bubale
cubage1178272cubage
curate85226242curate
debate94419192debate
extubate1745092extubate
humate113214442humate
intubate1047532intubate
jugate14379462jugate
lobate82915242lobate
lunate6316042lunate
luxate1338082luxate
mutate83017482mutate
nutate63017372nutate
outate62923402outate
pupate104213122pupate
quate144521412qu_ate
qubyte2034242qubyte
rebate84424102rebate
rubace10310172rubace
rubati8299692rubati
rubato8319672rubato
rugate75813812rugate
sublate9315362sublate
tate44748602t__ate
togate74515682togate
tuba65422362tuba__
tubal75517202tuba_l
tubas75119572tuba_s
tube65828662tub__e
tubulate1038272tubulate
tubule839852tubule
urate55432162_urate
abase76023483_abase
abated95918453_abated
abater85518123_abater
abates85825033_abates
ablate82219213ablate
actuate9311443actu_ate
acuate8315633acuate
adnate72913483adnate
adulate8313233adulate
aerate64830553aerate
agate66525143_agate
agnate73314873agnate
alate55340323_alate
albata839333albata
albite8313303albite
ambage11510593ambage
ansate64517863ansate
arbute8311043arbute
ate37059243___ate
aubades1038743aubades
augite7312613augite
aurae54128113aura_e
aurated83817793aurated
aureate72515283aureate
aviate9315203aviate
babe86835813__babe
bade75140883__bade
bake105637513__bake
bale66353843__bale
bane65250423__bane
barbate11314543barbate
bare65460523__bare
base64847023__base
baste74829983__baste
bat510988953__bat_
bated85935533__bated
bates75846343__bates
bath95940083__bath
bathe105822883__bathe
bats66962333__bats
batt65053873__batt
berate84729023berate
binate8419773binate
bite66546993__bite
blate75933783_blate
borate85026153borate
bubal94218213buba_l
bubales113513343bubales
bubals103513843bubals
bubble94016593bubble
bugbane1255863bugbane
bullate93415073bullate
bursate94111203bursate
butane8313653butane
bute66739673__bute
butte74924293bu_tte
byte96521813__byte
carate84734003carate
cate66254593__cate
caudate10311353caudate
cerate84829463cerate
comate104124843comate
crate76537403_crate
create85126373create
cubages1237923cubages
cubature1244683cubature
cube85830213cub__e
cubit94122883cubit_
cubiti10399073cubiti
cubits103714023cubits
cuneate9311723cuneate
curare84916953curare
curated104717583curated
curates95323823curates
curite85222943curite
curtate9312643curtate
cuspate1138233cuspate
cute66440453cu__te
date56443323__date
debase94014473debase
debated113916083debated
debater104114693debater
debates103718523debates
delate73827753delate
derate74531233derate
dilate73220693dilate
donate73619503donate
ducat86225903ducat_
ducats95011763ducats
dunite7315013dunite
educate10310213educate
elate55335883_elate
eluate62315433eluate
emulate9314123emulate
enate54428143_enate
equate152012463equate
ergate7315143ergate
estate64719763estate
extubated1944123extubated
extubates1844833extubates
exudate1537093exudate
fate75444283__fate
fixate1638733fixate
folate93320393folate
fubar1039923fuba_r
fugato1036223fugato
furane94015493furane
furcate12310453furcate
gate55746573__gate
gelate73421253gelate
globate1057823globate
grate64932883_grate
gunite7414403gunite
guttae73210583guttae
guttate8328903guttate
gyrate104912523gyrate
hamate113319823hamate
hate78450173__hate
humane112812173humane
humates122813193humates
ideate7313683ideate
incubate1238663incubate
ingate73018233ingate
inmate82917353inmate
innate63917313innate
intubated1246453intubated
intubates1147113intubates
iodate7313503iodate
irate55627983_irate
iterate71119103iterate
juba134916983juba__
jubas144614223juba_s
jube136322783jub__e
jubilate1746553jubilate
jubile152910253jubile
jurat124829323jurat_
jurats134213203jurats
jute115327893ju__te
karate105320923karate
labiate91313573labiate
lanate6421263lanate
late47560483__late
legate72917453legate
librate93214233librate
ligate72519243ligate
limbate1139203limbate
lobated102610943lobated
locate83919843locate
lube64731563lub__e
lucite8313343lucite
lunated8310823lunated
lute46341013lu__te
luxated1535713luxated
luxates1436973luxates
lyrate94112103lyrate
lysate9388103lysate
malate84624553malate
mate65154213__mate
maturate10312613maturate
metate82720533metate
misate81222693misate
muriate9313363muriate
mutase82811983mutase
mutated102712253mutated
mutates92215793mutates
mute65136873mu__te
negate72915573negate
nidate7313783nidate
niobate937703niobate
notate63217863notate
nubble103813713nubble
nubile83212703nubile
numbat10312083numbat_
numbats1137673numbats
nutated83113423nutated
nutates73214973nutates
oblate82214743oblate
obturate1077773obturate
oleate6318883oleate
opiate8513463opiate
orate55133303_orate
ornate6315133ornate
outage72017533outage
outbake13310773outbake
outdate83016423outdate
outrate72323183outrate
ovate84214393_ovate
ovulate1039453ovulate
palate84226783palate
pate65350463__pate
pedate93117763pedate
pirate82322883pirate
plate74635113_plate
plumate1149803plumate
prate75135983_prate
probate11414483probate
pulsate9510233pulsate
pupae96515643pupa_e
pupated12319353pupated
pupates113311433pupates
quake184114643qu_ake
quale143617853qu_ale
quare143920543qu_are
quarte154115323quarte
quatre153512353qu_atre
qubit164218983qubit_
qubits173710343qubits
qubytes2134383qubytes
quinate16511573quinate
quinte153414523quinte
quite144621463qu_ite
quote143714773qu_ote
rabat72832223rabat_
rabato83413263rabato
rabats83116223rabats
ramate83921683ramate
rate45458763__rate
rebated103619693rebated
rebater93517903rebater
rebates95123173rebates
rebato83714683rebato
redate74124683redate
relate64033633relate
remate84428683remate
rotate63320343rotate
rubaces1139303rubaces
rubasse934903rubasse
rubatos9278643rubatos
rubble104315673rubble
rube65532013rub__e
ruble74521253rub_le
rugae65114763ruga_e
ruinate7312833ruinate
sate45556103__sate
saturate8312813saturate
savate9313783savate
scutate9310323scutate
sedate73019803sedate
senate63725143senate
situate7410773situ_ate
skate94721543_skate
slate55438283_slate
solate64526073solate
sorbate9311733sorbate
spate74731583_spate
state56237333_state
stomate9313123stomate
striate74218953striate
stubble1136843stubble
stylate10179773stylate
suable83920553suable
suave83519873su_ave
suba64926603suba__
subacute1245753subacute
subah106015213suba_h
subahs114512383subahs
subarea939403subarea
subas74724073suba_s
subatom1147043subatom
subbase1139323subbase
subcaste1287853subcaste
subdue9128493subdue
subitem1138543subitem
subito8410443subito
sublated11311493sublated
sublates10315003sublates
sublet82827243sublet
subnet82520933subnet
subovate1347333subovate
subrace11313003subrace
subsale9310543subsale
subset83122583subset
subsite9412863subsite
substate101711083substate
subtle82113433subtle
subulate10312743subulate
suite54829563su_ite
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
sunbath1236423sunbath
sunbathe1344033sunbathe
surbase939793surbase
tabard9313333tabard
tabaret92717313tabaret
table75429603tab_le
tablet84227643tablet
tabulate10310893tabulate
tace65342513t__ace
tae38267053t__a_e
takahe1335793takahe
take84739263t__ake
tale46154163t__ale
tamale83717393tamale
tame66343663t__ame
tannate71813523tannate
tape64538143t__ape
tare45957623t__are
taste55127233t_aste
tat37690293t__at_
tater54138613t__ater
tates55444983t__ates
tats46858133t__ats
taxite13511303taxite
tease55428713t_ease
teat45963633t_eat_
teated74924023t_eated
teats55636813t_eats
telae54323293tela_e
tenace82715693tenace
terete6319333terete
ternate7415483ternate
testae64216253testae
testate73916233testate
thae76825563t_ha_e
thane86122533t_hane
that75639323t_hat_
theater104014253theater
theatre10358493theatre
thecate123210023thecate
thrave126010273thrave
tibiae838473tibiae
timbale11248793timbale
tirade7311693tirade
tisane6311573tisane
titrate72215573titrate
toccate1138773toccate
togae67020113toga_e
togated94410663togated
tolane64316583tolane
toluate7159343toluate
tomato8313453tomato
torte55431703t_orte
tote46643673t__ote
towage1039833towage
trabeate1049483trabeate
trace75829613t_race
trade65026043t_rade
trave85223033t_rave
treat56240353treat_
treated83618703treated
treater74219833treater
treats64821693treats
treaty94414353treaty
triage72812893triage
tribade1037283tribade
tribute937313tribute
triste63818643triste
trite54730033t_rite
truncate1046283truncate
tryste9399583tryste
tsade64311123t_sade
tsuba745563tsuba__
tuatera756363tu_atera
tub55640033tub___
tubaist938703tubaist
tubaists1055093tubaists
tubbable1134683tubbable
tubbed114712223tubbed
tubber104313203tubber
tubbier11237743tubbier
tubby124511393tub_by
tubed85818043tub_ed
tuber75420683tub_er
tubers85017023tubers
tubes74826453tub_es
tubful1136683tubful
tubifex1942063tubifex
tubing93813083tubing
tubist83013153tubist
tubists9288323tubists
tublike1337083tublike
tubs65430063tub__s
tubulated1256063tubulated
tubulates1147233tubulates
tubules9310233tubules
tucket124219483tucket
tufa75016613tufa__
tufas85314383tufa_s
tuffet122612083tuffet
tuft76929513tu_ft_
tufted10359283tu_fted
tufter9319933tu_fter
tufts85713273tu_fts
tufty114810413tu_fty
tugboat10126103tugboat_
tugboats11154103tugboats
tuille63012643tuille
tuladi765723tuladi
tule45735873tu__le
tulle54019933tu_lle
tumble103215643tumble
tuna45127843tuna__
tunable92511313tunable
tunas54224123tuna_s
tune45635863tu__ne
tunicate103310043tunicate
tunnage8166373tunnage
tuque14469193tu_que
turaco839453turaco
turban8310483turba_n
turbaned1145623turbaned
turbans939563turbans
turbary1236383turbary
turbeth1274713turbeth
turbinate1146673turbinate
turbine9310303turbine
turbit8715113turbit_
turbith1267113turbith
turbits969233turbits
turbot8914263turbot_
turbots988023turbots
turgite837973turgite
turret63121853turret
turtle63213573turtle
tusche1136783tusche
tushie939723tushie
tussle637143tussle
tut36758093tu__t_
tutee5423523tu_tee
tuts45838453tu__ts
tutted75117443tu_tted
tutti54614673tu_tti
tutty85217023tu_tty
tutu48423173tu__tu
tuyere9408613tuyere
twae74719573t_wa_e
twat75831513t_wat_
twats86616603t_wats
ukase9428493_ukase
ululate749963ululate
unbale83616403unbale
unbated103317733unbated
unite54828383_unite
update93810293update
uprate83916543uprate
urare56322553_urare
urase54624683_urase
urates65027763_urates
urbane82211383urbane
usage6410213_usage
ustulate868323ustulate
ute35335883_u__te
vacate11314553vacate
velate93720143velate
vibrate122811513vibrate
vulgate11388433vulgate
vulvate13388323vulvate
zonate154114923zonate

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.1401276364.3
2DLD Change Limit1127164875.65619928.6
3Display Results4874870.1563121.8
 (SQL Overall)1786914875.95230022.0
 
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.