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

121 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
tubas7511958(None) 
jubas144614221jubas
subas74724071subas
tuba65422361tuba_
tubae74716641tubae
tubal75517201tubal
tubes74826451tubes
tubs65430061tub_s
tufas85314381tufas
tunas54224121tunas
abas68642082_abas
abbas95918642abbas
albas75925392albas
auras55932562auras
babas96325732babas
bas58681752__bas
bubal94218212bubal
bubals103513842bubals
bubbas94110702bubbas
bubs86235502bub_s
bubus95115452bubus
bunas75126572bunas
buras74736302buras
cubes95028162cubes
cubs85832382cub_s
dubs78432192dub_s
dumas85420432dumas
duras65727732duras
fubar1039922fubar
fubs96328792fub_s
hubs96027142hub_s
hulas84920882hulas
isbas71010402isbas
juba134916982juba_
jubes145420742jubes
judas134911882judas
lubes74727992lubes
lumas75622912lumas
lunas55025012lunas
muras75329582muras
nubias8310092nubias
nubs65927142nub_s
obas65730932_obas
pubes94423402pubes
pubis94616472pubis
pubs85029212pub_s
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
rubes74928412rubes
rubs66133492rub_s
rubus76415062rubus
rumbas102512012rumbas
scubas103710222scubas
sobas74424252sobas
stubs75016072stub_s
stupas83910882stupas
suba64926602suba_
subah106015212subah
subahs114512382subahs
subs66037122sub_s
suras55336332suras
tabes76033922tabes
tablas83716162tablas
tabs66842982tab_s
tabus74820922tabus
takas95520682takas
talas55935892talas
tapas74627712tapas
tas38477102t__as
teas45851492t_eas
tepas76521682tepas
texas126514932texas
thujas1634432thujas
thuyas1234772thuyas
tibias839952tibias
toeas55726422toeas
togas67823002togas
tolas54532772tolas
toras55540372toras
tsuba745562tsuba_
tub55640032tub__
tubaist938702tubaist
tubate82813172tubate
tubby124511402tubby
tube65828662tub_e
tubed85818042tubed
tuber75420682tuber
tubers85017032tubers
tubist83013162tubist
tucks114721122tucks
tufa75016612tufa_
tuffs115118262tuffs
tufts85713272tufts
tugs56231672tu_gs
tuis44829642tu_is
tules54532792tules
tumps95420792tumps
tuna45127842tuna_
tunes55332192tunes
tungs65520622tungs
tuns45138662tu_ns
tups65628762tu_ps
turban8310482turban
turbans939562turbans
turbos8910782turbos
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
tusks94915532tusks
tuts45838452tu_ts
tutus55214812tutus
tuxes124316042tuxes
twas76824082t_was
upas68322382_upas
utas45924952_utas
yucas106013912yucas
yugas95012062yugas

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001211.41038156.0
3Display Results1211210.0304033.3
 (SQL Overall)1786911211.766101184.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.