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

168 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
ajowan163489(None) 
ajowans1734001ajowans
adown95611662adow_n
avowal1246322avowal
gowan95415742_gowan
jawan15710382_jawan
jowar155211432_jowar
rowan85418732_rowan
aboma91114603aboma_
abomas101113583abomas
aboon74918703abo_on
aboral8314373aboral
acorn75616623aco_rn
adjoin14107293adjo_in
adjourn1563433adjourn
adman84517903a_dman
adorn64917093ado_rn
adwoman1345433adwoman
aeolian738623aeolian
aeon45634613aeo__n
aeonian738353aeonian
afghan1333873afghan
agon56531883ago__n
agonal7410053agonal
agora6914333agora_
agorae7511203agorae
agoras7613343agoras
aidman92410623aidman
airman82414223airman
airway1237693airway
ajar116217703aj__ar
ajiva1586803ajiva_
ajivas1655133ajivas
ajuga1335883ajuga_
ajugas1435263ajugas
alan46844083a__lan
alloxan1445773alloxan
aloha8513613aloha_
alohas9411703alohas
aloin55227423alo_in
alow75328593alow__
alway116113923a_lway
ameban1039093ameban
amoeban1144913amoeban
amoral8314633amoral
anoa45634473ano_a_
anoas57226493ano_as
anodal72512123anodal
anon46134853ano__n
anorak1038923anorak
anuran64313243anuran
anyway1534803anyway
apian75018333a_pian
apodal9289833apodal
apogean1045443apogean
aroma71220143aroma_
aromas81018613aromas
ashcan1135843ashcan
ashman1148383ashman
aswoon947013aswoon
ataman81013063ataman
atman75520143a_tman
atonal6514023atonal
atwain937813a_twain
automan9310883automan
avian84616053a_vian
avow107816463avow__
avowals1335013avowals
avowed1335963avowed
avower1236823avower
avowing1466603avowing
avows114910983avow_s
awa611939673a__wa_
away108024223a__way
awn68035913a__w_n
awoken13457163awoken
axeman1538103axeman
axman144813183a_xman
axon115524303axo__n
axonal1347653axonal
azan136521783a__zan
azon135725053azo__n
azonal1568273azonal
blown105716673blow_n
bogan87519003_bogan
bowman13129853_bowman
brogan9311043brogan
brown105619533brow_n
cajon144513903cajo__n
clown105214733clow_n
cotan71521783_cotan
cowman13910373_cowman
crown105620083crow_n
deewan10267553deewan
dewan95718043_dewan
dioxan1465773dioxan
diwan95712553_diwan
down86427493_dow_n
drown95515823drow_n
flown116213993flow_n
frown115415973frow_n
goban84414073_goban
gowans105512293_gowans
gowany13457493_gowany
gown85724073_gow_n
groan65618423gro_an
grown95317353grow_n
hogan97817703_hogan
honan85319773_honan
hwan105716893__hwan
japan14411233_japan
jawans1657843_jawans
jean116629283_j_ean
john145512903_jo_hn
join116724833_jo_in
jomon14610083_jomon
joram145816983_joram
jordan1468063_jordan
jota116423623_jota_
jotas125717443_jotas
joual12311653_joual
jow137639303_jow__
jowars16369653_jowars
jowed164724423_jowed
jowing174216043_jowing
jowl146120303_jow_l
jowls156214523_jowls
jowly186410903_jowly
jows146632093_jow_s
known12568343know_n
koan85425033_ko_an
loan47436453_lo_an
logan68123283_logan
loran55925093_loran
lown76929293_low_n
moan65832023_mo_an
mown95424443_mow_n
noway111112843_noway
own66429703__ow_n
plowman1444933plowman
prolan8414693prolan
prowar114110943prowar
rewan85623663_rewan
roan47234203_ro_an
roman75424823_roman
rowans95715343_rowans
rowen84921153_rowen
ryokan1353753ryokan
seawan94111223seawan
sewan85921293_sewan
shoran94016043shoran
showman15257293showman
shown115216483show_n
slogan7539223slogan
snowman12226623snowman
solan55328153_solan
soman75024903_soman
sowans94215893_sowans
sowar85821343_sowar
sown75127453_sow_n
swan76631313__swan
teopan839353teopan
tolan55124013_tolan
toman75724053_toman
town76928703_tow_n
wan66761943___wan
woman105818003_woman
yeoman1138823yeoman

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.373479064.3
2DLD Change Limit1127161684.81323419.1
3Display Results1681680.0463652.2
 (SQL Overall)1786911685.23234153.5
 
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.