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

194 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
ubiety113591(None) 
dubiety1344581dubiety
bitty106119172_bitty
gaiety10119372gaiety
moiety1148222moiety
piety105817302_piety
unity84918492uni_ty
abbey125714933abbe_y
abet610547943ab_et_
abets75621673ab_ets
ability12311443ability
amity10416093ami_ty
anxiety1744033anxiety
aubrieta1043863aubrieta
banty106624003_banty
batty105422243_batty
bawty135614103_bawty
beefy135313833_beefy
beery105220123_beery
beet66457543_beet_
beets76131443_beets
beigy111110583_beigy
bet58376673_b_et_
beta66234133_b_eta
beth96629233_b_eth
bets67051443_b_ets
bevy127115223_b_evy
bey86645423_b_e_y
bialy105119323_bialy
biddy124612693_biddy
bidet84935623_bidet_
bidets95215533_bidets
bield84614653_bield
bier65531833_bie_r
biers76225223_biers
biffy164711133_biffy
biggety1434433_biggety
biggy124413133_biggy
bigly114814753_bigly
bilby124912353_bilby
bilgy114713713_bilgy
billy105525363_billy
bint67355043_bint_
bints76130183_bints
biota74516823_biota
birth105619873_birth
bit57070903_bi_t_
bite66547003_bi_te
biter75030033_biter
bites75641173_bites
bits66148163_bi_ts
bitsy104511303_bitsy
bitt65545813_bi_tt
bitts75022593_bitts
blet66247673_blet_
blets75324943_blets
booty106125913_booty
borty105522833_borty
briery114510773briery
built74325923built_
buret77444013buret_
burets84321263burets
busty105621013_busty
butty104020113_butty
chitty14329433chitty
city95122623_ci_ty
cubicity1746033cubicity
cubicly1644993cubicly
cubist104214443cubist_
cubists11359023cubists
cubit94122893cubi_t_
cubiti10399083cubi_ti
cubits103714033cubi_ts
dainty105311473dainty
deity94316773dei_ty
dicty115116293_dicty
diet57357533_diet_
diets66026643_diets
dirty95617803_dirty
ditty95019293_ditty
drifty13418223drifty
ebbet93517293ebbet_
ebbets10376833ebbets
feisty12449293feisty
fiery114714793_fiery
fifty145211423_fifty
flinty126112493flinty
flirty12499143flirty
furmety1534813furmety
gayety13116383gayety
gleety10479193gleety
glinty106910693glinty
gritty10338403gritty
guilty10418233guilty
impiety1445093impiety
kilty125213893_kilty
kitty124614563_kitty
laity85318903lai_ty
liberty1237163liberty
linty87126563_linty
milty104720073_milty
minty106323903_minty
misty106120453_misty
mity95528213_mi_ty
naivety1344283naivety
nicety1138433nicety
nifty115211633_nifty
nimiety1244633nimiety
ninety9510963ninety
nitty85418313_nitty
nubility1347783nubility
nudity1037993nudi_ty
nuggety1234313nuggety
obey96521303ob_e_y
obit66837083obi_t_
obits74617553obi_ts
objet141213143objet_
objets15125323objets
painty114714753painty
pieta75421753_pieta
pity96031933_pi_ty
pointy114913283pointy
puberty1444783puberty
purity114114913puri_ty
qubit164218993qubi_t_
qubits173710353qubi_ts
quiet144530733quiet_
quietly1945893quietly
quiets154014373quiets
rubbery14337593rubbery
rubied94312413rubie_d
rubier84814743rubie_r
rubies84420343rubie_s
rubiest92914423rubiest
russety1034613russety
safety12206913safety
satiety1038203satiety
shifty15409263shifty
shirty124312563shirty
shitty124110063shitty
silty84721633_silty
sixty154912733_sixty
skiey125012893skie_y
sleety94112653sleety
slitty9329163slitty
sobriety1343903sobriety
society1236083society
subitem1138553subitem
subito8410453subi_to
sublet82827243sublet_
sublets92616703sublets
subnet82520933subnet_
subnets92512083subnets
subset83122583subset_
subsets92813103subsets
subtilty1345453subtilty
subtlety1345063subtlety
suety85318493_suety
surety93515013surety
thirty12378403thirty
titty85316653_titty
tubist83013163tubist_
tubists9288323tubists
twisty12426863twisty
ubieties1046913ubieties
ubique1784883ubique
ubiquity2243073ubiquity
unify113611113uni_fy
unit45140073uni_t_
unite54828383uni_te
united74421543united
uniter64619143uniter
unites65024853unites
units54923433uni_ts
unlet54133333unlet_
unmet74426393unmet_
unset54532433unset_
unsets64116163unsets
unsexy16296903unsexy
unwet84423173unwet_
uppity1335103uppity
upset73222593upset_
upsets8409683upsets
utility1038703utility
variety1337743variety
viewy14518103_viewy
whitey154911883whitey
whity145513473whi_ty
wifty144212093_wifty
witty114717013_witty
wristy12509703wristy
zibet16419733zibet_
zibeth2034173zibeth
zibets1737743zibets

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.1231452772.4
2DLD Change Limit1127161945.00022543.2
3Display Results1941940.0633079.4
 (SQL Overall)1786911945.18634456.4
 
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.