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

307 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
phalli114826(None) 
phallic1447291phallic
thalli958911thalli
challa114014192challa
challie124012852challie
challis124613462challis
chally144314292chally
chilli114312772chilli
hall75741162_hall_
hallo85127552_hallo
halls85633782_halls
pall65039342p_all_
pallia83015592p_allia
pallid93915272p_allid
palls74332562p_alls
pally105727122p_ally
palpi95414552p_alpi
phallism1545712phallism
phallist1338982phallist
phallus1236062phallus
phyllo1435872phyllo
shall85024052shall_
thallic1246542thallic
aalii5316123_aalii
ahull84010313ahull_
all36148233__all_
alls46740923__alls
ally76935643__ally
anally9513503anally
aphylly1843353aphylly
appall10379743appall_
appalls11337743appalls
ball66043323_ball_
balls76236413_balls
bally105530103_bally
bhakti1544323bhakti
biali73419073bia_li
call66838673_call_
calla74827073_calla
calls75634733_calls
celli76717693_celli
chablis14368553chablis
chadri1238133chadri
chai95929903cha__i
chalah143511653chalah
chalcid1537873chalcid
chaleh143711993chaleh
chalet113825993chalet
chalk144814603cha_lk
chalks155412143chalks
chalky18468773chalky
challah15458323challah
challas124414123challas
challies133915633challies
challot123613263challot
chalot113020133chalot
charlie123011923charlie
chili106218483ch_ili
chill105619873chill_
chillis124411603chillis
chills114717703chills
chilly144113223chilly
cholla113911023cholla
dally95324743_dally
dhal86719283dha_l_
dhals95415443dha_ls
dually103210063dually
duelli767003duelli
fall75535313_fall_
falls85727653_falls
gall56335993_gall_
gallic9411633_gallic
galls64729323_galls
gally95026173_gally
gharri10386163gharri
ghazi1837433gha_zi
ghibli1243493ghibli
ghillie11326353ghillie
ghyll1246323ghyll_
ghylls1335143ghylls
hadji16839873_hadji
hail74839063_hail_
hails85231643_hails
haji148520183_ha_ji
hajji14677453_hajji
halal85623593_halal
halala94715093_halala
halals95018313_halals
hale76052833_ha_le
haled95335823_haled
haler85033523_haler
hales85449843_hales
half106238453_ha_lf
halid94424973_halid
hallah124115403_hallah
hallal94415563_hallal
hallel93514093_hallel
halloa94918123_halloa
halloo95118973_halloo
hallos95425103_hallos
hallot95426783_hallot
hallow124818323_hallow
hallux1637363_hallux
halm95834973_ha_lm
halma108219253_halma
halms105225213_halms
halo76437323_ha_lo
haloid104317753_haloid
halon86124863_halon
halos85230253_halos
halt76056303_ha_lt
halts85230103_halts
halva115414433_halva
halve114818923_halve
hamuli1137053_hamuli
haole84820083_haole
haply135915063_haply
harl75740003_harl_
harls85634503_harls
haul75530453_haul_
haulm104415413_haulm
hauls86123733_hauls
hell75637893_hell_
hello86522983_hello
hells85032043_hells
hili75626633_h_ili
hill76439493_hill_
hillo84721653_hillo
hills85431353_hills
hilly114422163_hilly
holla84918493_holla
hollo84822163_hollo
holly114824433_holly
hull75428783_hull_
hullo84417453_hullo
hulls84923563_hulls
khadi1367603kha_di
khaki1157643kha_ki
khalif1657833khalif
lall45531313_lall_
lalls55324133_lalls
leally94012613leally
mall64639363_mall_
mallei84414633_mallei
malls76233433_malls
nielli636303nielli
ocelli836843ocelli
omphali1444503ompha_li
orally93113593orally
ovally12278443ovally
padi76331783p_a_di
padle84522343p_adle
padri85815163p_adri
paella8410913paella
pahlavi1542643pahlavi
pail66141833p_ail_
pails75833063p_ails
pal56761673p_a_l_
palais8420423p_alais
pale66055013p_a_le
palea75028663p_alea
paled85538723p_aled
palely11311923p_alely
paler75436933p_aler
pales75753803p_ales
palet74650803p_alet
palled94625163p_alled
pallet84232653p_allet
pallial92911253p_allial
pallier94417163p_allier
palling104024483p_alling
pallium1149013p_allium
pallor8313673p_allor
palm85331363p_a_lm
palms94921753p_alms
palmy126016733p_almy
palp85828573p_a_lp
palps94719563p_alps
pals66951353p_a_ls
palsy105417463p_alsy
paly95835533p_a_ly
papally1437973papally
pappi84810893p_appi
pardi85723953p_ardi
parle75836163p_arle
patly105020583p_atly
paulin8312983p_aulin
pawl95123263p_awl_
pawls105617663p_awls
peal68648103pea_l_
pealed95322803pealed
peals75235493pea_ls
pearl75324463pearl_
pearls84715383pearls
pearly116414843pearly
penally121111763penally
phage115113673pha_ge
phages125213513phages
phalanx1945203phalanx
phallisms1645073phallisms
phallists1445723phallists
pharos11312063pharos
phase104617213pha_se
phased124011973phased
phases114618403phases
phasic133612053phasic
phasis114614923phasis
phasmid15267603phasmid
phat95837863pha__t
phatic133014403phatic
phellem1435833phellem
phi86524203ph___i
phial10313203phial_
phials1158873phials
phlox1737333ph_lox
phyla13469183ph_yla
phylae14458733phylae
phylar14437373phylar
phyle134111153ph_yle
phylic16279553phylic
phyllite1645743phyllite
phylloid1746183phylloid
phyllos1535583phyllos
phylon14318033phylon
phylum1655153phylum
pial65636703pia_l_
pilei74021783p_ilei
pili66130353p__ili
pill65339463p_ill_
pills74130973p_ills
poll66332133p_oll_
polls74627723p_olls
prill74117943prill_
prills84015613prills
prothalli1444773prothalli
psalm949273psa_lm
psalmic1345333psalmic
psalms1045673psalms
psylla1133953psylla
psyllid1344513psyllid
puli65527623p__uli
pull64731663p_ull_
pulls74425053p_ulls
rally84725903_rally
really93315613really
sall44544683_sall_
sally85129713_sally
salmi7815863_salmi
scall74420373scall_
scalls84218203scalls
shale85332833sha_le
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shalom11810913shalom
shalt85534483sha_lt
shaly114322863sha_ly
shanti94014073shanti
shaslik1444503shaslik
shaul85418103shaul_
shauls94913113shauls
shawl116217573shawl_
shawls125411973shawls
shell84424123shell_
shells94319523shells
shelly124414463shelly
shill85325333shill_
shills94519603shills
small74016263small_
smalls84514123smalls
smalti84111173smalti
spall74919303spall_
spalls84217343spalls
stall54722353stall_
stalls64019923stalls
tali46837163_ta_li
tall47240213_tall_
tallis63319963_tallis
tallit63422733_tallit
talls55133433_talls
tally84526863_tally
thalami1246053thalami
thaler94613103thaler
thallium1344433thallium
thalloid1246263thalloid
thallus1035603thallus
thill85918733thill_
thills95515383thills
tholoi9339223tholoi
thrall93810293thrall_
thralls10299043thralls
uphill11106173uphill_
uphills1295233uphills
villi86517853_villi
wall76236103_wall_
walla85321033_walla
wallie93216803_wallie
walls85529383_walls
wally114625093_wally
whale115517433wha_le
whaled134612033whaled
whaler124611973whaler
whales124716943whales
wholly15366573wholly

Search took 8 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.1731032896.0
2DLD Change Limit1127163076.84316471.7
3Display Results3073070.0933301.1
 (SQL Overall)1786913077.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.