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

133 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
phallic144729(None) 
phalli1148261phalli_
thallic1246551thallic
challie124012852challie
challis124613462challis
gallic9411642_gallic
pallia83015592p_allia
pallid93915282p_allid
phallism1545712phallism
phallist1338992phallist
phallus1236062phallus
phasic133612052pha_sic
phatic133014412pha_tic
phylic16279552ph_ylic
psalmic1345332psalmic
thalli958922thalli_
aphasic142810063apha_sic
asphaltic1644603asphaltic
aulic74420243__aulic
calcic9311873_calcic
cephalic1777903cepha_lic
chablis14368563chablis
chalcid1537883chalcid
chalice14311043cha_lice
challa114014193chall_a
challah15458323challah
challas124414123challas
challies133915643challies
challot123613263challot
chally144314293chall_y
chaotic14310043chaotic
charlie123011923charlie
chasmic16177983chasmic
chilli114312773chilli_
chillis124411603chillis
dharmic1535023dharmic
gallica1047463_gallica
garlic9310043_garlic
ghillie11326353ghillie
haemic133210083_haemic
halakic1656663_halakic
halid94424983_ha_lid
hall75741163_hall__
hallah124115403_hallah
hallal94415563_hallal
hallel93514093_hallel
hallo85127553_hall_o
halloa94918123_halloa
halloo95118973_halloo
hallos95425103_hallos
hallot95426783_hallot
hallow124818323_hallow
halls85633783_hall_s
hallux1637363_hallux
haloid104317763_haloid
haptic13511893_haptic
holmic1338783_holmic
idyllic1342973idyllic
italic839903ita_lic
khalif1657833kha_lif
malic94525663_ma_lic
medallic1345113medallic
metallic1247643metallic
myalgic15134223myalgic
otalgic1045063otalgic
oxalic1537093oxa_lic
pachalic1757273pacha_lic
palais8420423p_alais
pall65039343p_all__
palladic1346113p_alladic
palled94625163p_alled
pallet84232653p_allet
pallial92911253p_allial
pallier94417163p_allier
palling104024483p_alling
pallium1149013p_allium
pallor8313673p_allor
palls74332563p_all_s
pally105727123p_all_y
palpi95414553p_alpi_
panic93923903p_a_nic
pashalic1546183pasha_lic
paulin8312983p_aulin
pelagic1237863pelagic
pelvic13307553p_elvic
phalanx1945203phalanx
phallicism1952633phallicism
phallisms1645073phallisms
phallists1445723phallists
phasis114614923pha_sis
phasmid15267603phasmid
phellem1435833phellem
phenolic1546813phenolic
phenylic1844483phenylic
phobic153010073ph_obic
phonic133315213ph_onic
photic133316443ph_otic
phratric1545953phratric
phrenic1438773phrenic
phthalic1855573phthalic
phyletic1847213phyletic
phyllite1645743phyllite
phyllitic1944423phyllitic
phyllo1435873phyll_o
phylloid1746193phylloid
phyllomic2143383phyllomic
phyllos1535583phyllos
physic16288473ph_ysic
pianic103714123pia_nic
plasmic13249113plasmic
plastic112815063plastic
practic13312253practic
psyllid1344523psyllid
public12238143p_ublic
pyaemic1645873pyaemic
salic73424713_sa_lic
scaldic1235943scaldic
shall85024053shall__
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shaslik1444513shaslik
shellac1236693shellac
sialic8313633sia_lic
skaldic1443553skaldic
tallis63319963_tallis
tallit63422733_tallit
thalamic1545553thalamic
thallium1344433thallium
thalloid1246283thalloid
thallus1035603thallus
thiolic1247323thiolic
wallie93216803_wallie

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.440406115.9
2DLD Change Limit1340271336.11021935.7
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.59627090.8
 
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.