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

276 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
shortie1041134(None) 
shortia1048191shortia
shorties11414581shorties
sortie63621991s_ortie
chortle124210442chortle
dhootie1136472dhootie
hogtie102711772_hogtie
hottie92514382_hottie
scottie937462scottie
sharpie1238402sharpie
sheltie10109912sheltie
shirtier1137942shirtier
shore85432652shor__e
short85040532short__
shortage1236312shortage
shorted113614402shorted
shorten103511412shorten
shorter103515502shorter
shortias1148092shortias
shorting122514802shorting
shortish1437422shortish
shortly13387572shortly
shorts95321742short_s
shorty124313202short_y
shote85526102sho_t_e
showtime1643772showtime
smartie9310172smartie
softie93312482s_oftie
sortied83314102s_ortied
sorties74126402s_orties
sportier102010052sportier
sportif1238802sportif
sportive1348332sportive
thorite10313442thorite
whortle13335942whortle
abortive1346883abortive
ahorse9311513ahor_se
amortise10428513amortise
amortize1987743amortize
aortae65115473_aortae
aortic8316613_aortic
ashore9414613ashor__e
bhistie1236773bhistie
bootie85421163_bootie
charlie123011923charlie
chertier1387873chertier
chlorite133012843chlorite
chorale124313353chorale
chore105126763chor__e
choreic1438703choreic
choric133515903chor_ic
chorine123218363chorine
choroid13311803choroid
chorten122811303chorten
chortled14326613chortled
chortler13336843chortler
chortles133611323chortles
chowtime1842953chowtime
coontie9311423coontie
cootie84223093_cootie
corbie103618203_corbie
corrie83621233_corrie
cortin82423153_cortin
dhooti1035663dhooti_
dhooties1237643dhooties
dhootis1135683dhootis
dhoti9310123dho_ti_
dhotis1038973dho_tis
dhurrie1153953dhurrie
diorite8314913diorite
dormie9312623_dormie
footie94718143_footie
forte86131463_fort_e
forties104323863_forties
fortis95418613_fortis
ghostier1235383ghostier
ghoulie1144263ghoulie
hoagie102310013_hoagie
hogtied12226653_hogtied
hogties112813993_hogties
homie104622533_ho_mie
honkie133011673_honkie
hoodie105116143_hoodie
hoolie93217783_hoolie
hootier104915353_hootier
horde94623053_hor_de
hornier103012463_hornier
horrid10311563_horrid
horse86132653_hor_se
horsier103013243_horsier
horste94817413_horste
hostile10312553_hostile
hotties103016963_hotties
howdie13349733_howdie
hurtle93512943_hurtle
mortice11711493_mortice
mortise9713533_mortise
norite63221133_norite
oorie53026363_oor_ie
phorate12413363phorate
photic133316443pho_tic
postie84123963_postie
prostie91617743prostie
rhotic112711233rho_tic
saltie63422433s_altie
score75526743scor__e
scoria8513503scor_ia
scoriae9310903scoriae
scotia8310803sco_tia
scotties1039753scotties
serotine8313573serotine
shanti94014093shanti_
shanties113116593shanties
shantih13309643shantih
shantis103313103shantis
share86437083shar__e
sharia93116733shar_ia
sharif122917123shar_if
sharpies13411233sharpies
shavie124312423sh_avie
sheathe1348993sheathe
sheenie10159493sheenie
shelties111111383shelties
sherif122915243sher_if
sherries111812903sherries
sherris10168803sherris
shiftier1436343shiftier
shire84727133shir__e
shirt84533903shirt__
shirtiest1239333shirtiest
shirting123213613shirting
shirts94918343shirt_s
shirty124312563shirt_y
shittier1137313shittier
shittim1245133shittim
shoalier1137073shoalier
shoat85633953shoat__
shoats94117083shoat_s
shoddier1334213shoddier
shoddies1336053shoddies
shoe75933443sho___e
shoetree1146583shoetree
shogi95014013sho_gi_
shogis103810943sho_gis
shoji15419963sho_ji_
shojis16348493sho_jis
shone83725983sho__ne
shoot84235913shoot__
shooter103013993shooter
shooting122812863shooting
shoots94619363shoot_s
shoppe133110323sho_ppe
shoran94016043shor_an
shorans102812413shorans
shored105723653shor_ed
shoreline1246623shoreline
shores94830413shor_es
shoreside1344733shoreside
shoring112820073shoring
shorl84720253shor__l
shorls94516203shor_ls
shorn85722183shor__n
shortages1336513shortages
shortcake1843203shortcake
shortcut1344453shortcut
shortened1345663shortened
shortener1245773shortener
shortens11288993shortens
shortest11310783shortest
shorthair1543023shorthair
shorthead1644473shorthead
shortlist1246683shortlist
shortness1236733shortness
shortwave1842483shortwave
shot76150263sho_t__
shotes95321913sho_tes
shots84730853sho_t_s
shott85332193sho_t_t
shotted113912403shotted
shotten10288463shotten
shotting123012383shotting
shotts93614703sho_tts
shout85433173shout__
shouted113911553shouted
shouter103213083shouter
shouting122711793shouting
shouts94017723shout_s
shove114421043sho__ve
showbiz2453223showbiz
showier1339103sho_wier
showtimes1743653showtimes
shri76021703sh_r_i_
shriek134211103sh_r_iek
shrike134513243sh_rike
shrine94920053sh_rine
shris84221453sh_r_is
shrive125216953sh_rive
shrove125412233sh_rove
shtik123210963sh__tik
shute84520353sh_ut_e
shuttle1046103shuttle
shvartze2341873shvartze
skort94925643skort__
skorts104211303skort_s
smarties10312873smarties
smoothie1344893smoothie
smote75820283smo_t_e
snootier8278383snootier
snore55424953snor__e
snort54833753snort__
snorted83813493snorted
snorter74412663snorter
snorting92613373snorting
snorts64116503snort_s
snottier8217383snottier
snoutier8206973snoutier
softies103414613s_ofties
somite84519373s_omite
sonsie6614863s_onsie
soothe94214853s_oothe
sootier73916613s_ootier
sopite84917713s_opite
sorbic10310393s_orbic
sordid83411163s_ordid
sordine82515233s_ordine
sore47059533s_or__e
sori46039843s_or_i_
sorites73825243s_orites
soritic91414433s_oritic
sorptive1346473s_orptive
sorrier72313733s_orrier
sort46264813s_ort__
sorta57125413s_ort_a
sorted74523713s_orted
sorter64425093s_orter
sorting83221813s_orting
sorts54536663s_ort_s
spore75428593spor__e
sporoid102310733sporoid
sport75935983sport__
sported104015433sported
sporter93616553sporter
sportiest111711033sportiest
sportily1337733sportily
sporting112415463sporting
sports84619183sport_s
sporty115112493sport_y
sporule937273sporule
spottier10207313spottier
sprite84421773s_prite
spurtle937453spurtle
startle72511123startle
stogie7311323sto_gie
stoolie739723stoolie
storage8310473storage
store56333813stor__e
storied8515163stor_ied
stories7324273stor_ies
stormier1036103stormier
stotin63215063sto_tin
stourie7469353stourie
sweetie10157873sweetie
swore84920823swor__e
thirties1139723thirties
thoria93012893thor_ia
thoric114314043thor_ic
thorites11312393thorites
thornier1135323thornier
thorpe113610093thor_pe
torte55431703_tort_e
tortile7313193_tortile
whoopie15295933whoopie
whore116018043whor__e
whort114623693whort__
whortles14306743whortles
whorts125111433whort_s

Search took 7 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.423422437.4
2DLD Change Limit1340272766.14021828.5
3Display Results2762760.1102509.1
 (SQL Overall)1786912766.67326778.2
 
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.