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

213 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
qwerty213358(None) 
qwertys224971qwertys
cherty144612472cherty
query174212082quer_y
swarty125812382swarty
sweaty123710052sweaty
twenty1236222twenty
warty119323822_warty
wert79749822_wert_
aery77231683_aer_y
alert54740653alert_
alertly1046793alertly
alerts64418223alerts
anergy10156863anergy
apery106517903aper_y
arty77531313__arty
avert86029493avert_
averts95715243averts
aweary1237303aweary
awry107619683aw_r_y
beery105220123beer_y
berry104521773_berry
berth104917883_berth
bewray14147733bewray
borty105522833_borty
bowery146012113bower_y
cherry144810763cherry
chert105232103chert_
cherts115617233cherts
chesty144610503chesty
clergy1234993clergy
deity94316773_deity
deray95024183_deray
derby114715343_derby
derry94721373_derry
dirty95617803_dirty
dorty96220813_dorty
dowery134311663dower_y
dweeby1542993dweeby
dwelt94316523dwelt_
eery76129623_eer_y
emery104814333emer_y
energy10137513energy
equerry1943053equerry
evert84929513evert_
everts94514893everts
every115215453ever_y
ewer77523983ewer__
ewers86018823ewer_s
exert124624143exert_
exerts133712293exerts
faery116015483faer_y
ferity122813343_ferity
ferly115517353_ferly
ferny115816183_ferny
ferry116020803_ferry
fiery114714793fier_y
flirty12499143flirty
forty114824273_forty
fretty1249223fretty
germy115113663_germy
gleety10479193gleety
hearty126313633hearty
hefty146112133_hefty
herby134715313_herby
herry114922473_herry
hertz174919043_hertz
inert53234373inert_
inertly1038543inertly
inerts64517023inerts
jerky196712423_jerky
jerry155016183_jerry
jetty156212583_jetty
kerry124916093_kerry
leery85919133leer_y
lefty115613563_lefty
liberty1237163liberty
lowery124112713lower_y
meaty107021313_meaty
melty104918363_melty
mercy125916183_mercy
merry104721493_merry
nerdy95014703_nerdy
nerts55924983_nerts
nertz145117453_nertz
nervy114610863_nervy
netty85816763_netty
onery8414123oner_y
overly122411363overly
overt85630723overt_
overtly13268983overtly
party106630613_party
peaty105725693_peaty
peery105719443peer_y
perdy115417333_perdy
perky145319483_perky
perry105222713_perry
pert66759323_pert_
pertly115312553_pertly
pesty106421713_pesty
petty105320293_petty
piety105817303pie_ty
plenty11311413plenty
poetry1139383poetry
poverty1536433poverty
pretty11510873pretty
puberty1444783puberty
purty105019403_purty
quarry1837473quarry
quart144027853quart_
quarte154115323quarte
quarto153511123quarto
quarts154715933quarts
quartz244212103quartz
queasy1855173queasy
queazy2743573queazy
queerly1934233queerly
quern143610403quer_n
querns15307943querns
quest144121323quest_
quests153310353quests
quey164616473que__y
quirky22435533quirky
quirt144624233quirt_
quirts154213553quirts
retry84718083_retry
serry84824123_serry
shelty124011553shelty
sherry124510413sherry
shirty124312563shirty
shorty124313203shorty
skerry13356103skerry
sleety94112653sleety
smarty115013793smarty
sporty115112493sporty
suety85318493sue_ty
surety93515013surety
swart86234643swart_
swarth126012083swarth
swarthy16466373swarthy
sweat85628403sweat_
sweats94814613sweats
sweeny12358843sweeny
sweepy14447453sweepy
sweet85330523sweet_
sweetly1335593sweetly
sweets94214433sweets
sweltry1333413sweltry
swept105720603swept_
swerve1256293swerve
swirly12439253swirly
tarty86328183_tarty
tenty86121603_tenty
terry84721873_terry
testy85419063_testy
thirty12378403thirty
towery124012093tower_y
treaty94414353treaty
tweaky1634023tweaky
tweedy13455933tweedy
tweeny12477003tweeny
tweet84823983tweet_
tweets94210103tweets
twerp10398413twer_p
twerps11345153twerps
twirly12427083twirly
twisty12426863twisty
veery115816253veer_y
verity123714853_verity
vert77249373_vert_
verts85724733_verts
vertu85017613_vertu
very108025643_ver_y
wart77866083_wart_
warts814840403_warts
wary106740013_war_y
weary115620613_weary
webby1537153_webby
wedgy13479803_wedgy
weedy125115003_weedy
weeny115316163_weeny
weepy134212593_weepy
weet75254153_weet_
weets85427723_weets
weft105435013_weft_
wefts116715493_wefts
weirdy13395463_weirdy
welly114620013_welly
welt75547863_welt_
welts85225193_welts
wenny114412463_wenny
went76051873_went_
wept95635053_wept_
were76238333_wer_e
west75748083_west_
wests85727003_wests
wet65966623_we_t_
wetly114511713_wetly
wets75940293_we_ts
wherry15477343wherry
whity145513473_whity
wifty144212093_wifty
wiry106422833_wir_y
witty114717013_witty
wordy126916163_wordy
wormy137514253_wormy
worry116114333_worry
wort76654753_wort_
worth117120523_worth
worthy15598803_worthy
worts88631183_worts
wry96524703_w_r_y
zesty176512163_zesty

Search took 10 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.436409841.7
2DLD Change Limit1127162138.57613143.2
3Display Results2132130.0802662.5
 (SQL Overall)1786912139.09219653.7
 
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.