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

255 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
tubists928832(None) 
cubists11359021cubists
tubaists1055101tubaists
tubist83013161tubist_
aurists74615782aurists
autists73814852autists
cubisms13306882cubisms
cubist104214442cubist_
cubits103714032cubi_ts
jurists14409122jurists
lutists73810272lutists
nudists8356832nudists
purists94014072purists
qubits173710352qubi_ts
subsists1037992subsists
tanists7313652tanists
theists1039152theists
tourists838312tourists
tubaist938702tubaist_
tubings10336482tubings
turbits969232turbi_ts
turista737442turista
turistas846692turistas
twists9549752t_wists
typists1236172typists
vibists1256482vibists
ageists848493ageists
agists75713173_agists
ambits103713413ambi_ts
aorists74215833aorists
artists74215593artists
assists738473assists
atavists1137583atavists
atheists1138713atheists
atomists102610963atomists
audits72814113audi_ts
aurist65027253aurist_
autisms94311553autisms
autist64324943autist_
basts75936933__basts
bemists113410703bemists
bests75932613__bests
biblists1236873biblists
bints76130183__bints
bises75435623__bises
bisks115416803__bisks
bits66148163__bi_ts
bitts75022593__bitts
blurbists1343273blurbists
bundists1145383bundists
bursts85116243bu_rsts
busts75227693__busts
cambists1437023cambists
chutists1335583chutists
cists76624533__cists
cubics123810163cubi_cs
cubism12348703cubis_m
cubistic1445703cubistic
cubit94122893cubi_t_
cubiti10399083cubi_ti
cubitus11346783cubitus
cultists10107633cultists
cutises94414913cutises
debits94214503debi_ts
deists74916433_deists
delists84414173delists
desists83611723desists
dualists958243dualists
dubiety1344583dubiety
dubious1036893dubious
duelists966003duelists
duits65021883du_i_ts
dusts65923563du__sts
egoists887073egoists
enlists749393enlists
exists134710913_exists
fauvists1443843fauvists
feists94915313_feists
feudists1244463feudists
fists85527543__fists
flutists11256413flutists
foists95413983_foists
fuguists1243693fuguists
futurists1245583futurists
gists66026193__gists
grists74716483_grists
guests74311203gu_ests
guilts74111233gu_ilts
guises74216313gu_ises
gusts65722793gu__sts
habits113014653habi_ts
heists96814633_heists
hists86328373__hists
hoists95516023_hoists
holists104413963holists
hubrises1337103hubrises
hursts97213093hu_rsts
ibises83610543_ibises
insists739083insists
joists134711033_joists
jubiles16289373jubiles
judoists1643653judoists
jujuists1442273jujuists
jurist134616393jurist_
justs124918263ju__sts
kists95822113__kists
kumiss1235923kumis_s
legists899593legists
lists56628693__lists
lusts55022803lu__sts
lutist64317553lutist_
lyrists1036963lyrists
maists85817573_maists
mists76633903__mists
monists93614783monists
musts75527443mu__sts
mutisms11338453mutisms
naturists947513naturists
nubias8310093nubi_as
nudisms10305853nudisms
nudist73813323nudist_
obits74617553_obi_ts
oboists937903oboists
oculists1037133oculists
odists749853_odists
orbits84211443orbi_ts
ousts55225703ou__sts
outsits73215253outsits
papists112110453papists
pubis94616473pubi__s
purisms114110833purisms
purist85525053purist_
qubit164218993qubi_t_
querists1736543querists
quests153310353qu_ests
quiets154014373qu_iets
quilts154112543qu_ilts
quints154316563qu_ints
quirts154213553qu_irts
quits144122353qu_i_ts
quoits15379683quoi_ts
racists92613323racists
rapists92510753rapists
relists73817053relists
resists74414923resists
rubies84420343rubi_es
rubiest92914423rubiest_
rubigos1033653rubigos
rubious938283rubious
rubouts937983rubouts
rusts55026993ru__sts
sadists83310853sadists
schists1248543schists
sexists14267673sexists
shists96515113_shists
soubises10107993soubises
statists8310163statists
stylists11207023stylists
subito8410453subi_to
sublets92616703sublets
sublots92410913sublots
submiss1138083submis_s
submits1139753submits
subnets92512083subnets
subsets92813103subsets
subsist9311573subsist_
subsite9412873subsite
subsites10312783subsites
subtests1037533subtests
suints64617783su_ints
suits55028053su_i_ts
sumoists1046733sumoists
tabbises12236523tabbises
tablets94714383tablets
tachists1348183tachists
taints64520533t_aints
tamises92715973tamises
tanist6324593tanist_
tapises92914013tapises
tennists8297793tennists
tests56530193t__ests
theisms1237763theisms
theist9314763theist_
thirsts1036243thirsts
thrifts1335523thrifts
thrusts10226523thrusts
tibias839953tibi_as
tidbits1035183tidbi_ts
tilts55325613t__ilts
tints56030923t__ints
titbits935803titbi_ts
titlists837293titlists
tits46145043t__i_ts
toasts65914993t_oasts
tobies84521023tobi_es
toits55327473t_oi_ts
tourisms1037613tourisms
tourist7313203tourist_
tourista844403tourista
touristas943373touristas
touristy1144513touristy
traits65121983trai_ts
triste63818643t_riste
truisms9106823truisms
trusts64714433t_rusts
trysts9448793t_rysts
tsarists857303tsarists
tubas75119583tub__as
tubate82813173tub_ate
tubbers113411253tubbers
tubbiest12117293tubbiest_
tubers85017033tub_ers
tubes74826453tub__es
tubfuls1245483tubfuls
tubifex1942063tubifex
tubing93813093tubi_ng
tubs65430063tub___s
tubules9310233tubules
tuckets134810333tuckets
tuffets13266523tuffets
tufts85713273tu__fts
tugboats11154103tugboats
tuis44829643tu_i__s
tulips8137253tuli_ps
tumults934823tumults
tunics83811263tuni_cs
tupiks1235493tupi_ks
turbines1039903turbines
turbit8715113turbi_t_
turbith1267113turbi_th
turbiths1374083turbiths
turbots988023turbots
turions7311573turions
turrets73010673turrets
tusks94915533tu__sks
tusses64921243tu_sses
tussis6379953tu_ssis
tussises835433tussises
tuts45838453tu___ts
twist86820983t_wist_
twisty12426863t_wisty
twits86015793t_wi_ts
typist1139823typist_
tzarists1755693tzarists
ubiety1135913_ubiety
units54923433_uni_ts
utmosts934593utmosts
utopists1045773utopists
verists103613673verists
vibist11610583vibist_
waists97415453_waists
whists124613813_whists
wists86728523__wists
wrists95415643_wrists
wursts95211163wu_rsts

Search took 8 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 Limit1340272556.81319672.2
3Display Results2552550.0932741.9
 (SQL Overall)1786912557.29624491.6
 
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.