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

128 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
thallic124655(None) 
phallic1447291phallic
thalli958921thalli_
challie124012852challie
challis124613462challis
gallic9411642_gallic
phalli1148262phalli_
tallis63319962t_allis
tallit63422732t_allit
thalamic1545552thalamic
thallium1344432thallium
thalloid1246282thalloid
thallus1035602thallus
thiolic1247322thiolic
aulic74420243__aulic
calcic9311873_calcic
chablis14368563chablis
chalcid1537883chalcid
chalice14311043cha_lice
challa114014193chall_a
challah15458323challah
challas124414123challas
challies133915643challies
challot123613263challot
chally144314293chall_y
chaotic14310043chaotic
charlie123011923charlie
chasmic16177983chasmic
chilli114312773chilli_
chillis124411603chillis
dharmic1535013dharmic
ethylic1546323eth_ylic
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
pallia83015593_pallia
pallid93915283_pallid
phallism1545713phallism
phallist1338983phallist
phallus1236063phallus
phasic133612053pha_sic
phatic133014413pha_tic
phthalic1855573phtha_lic
phylic16279553ph_ylic
psalmic1345333psalmic
salic73424713_sa_lic
scaldic1235943scaldic
shall85024053shall__
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shaslik1444513shaslik
shellac1236693shellac
sialic8313633sia_lic
skaldic1443553skaldic
tactic10612753t_actic
talc66226813t_a_l_c
tali46837163t_a_li_
talkie103914443t_alkie
tall47240213t_all__
taller63721963t_aller
tallied83314753t_allied
tallier72817213t_allier
tallies73624603t_allies
tallish103313583t_allish
tallith102913063t_allith
tallits73215993t_allits
tallol63612223t_allol
tallow93714203t_allow
talls55133433t_all_s
tally84526863t_all_y
tannic82811473t_annic
telic76019823t__elic
thalami1246083thalami
thalassic1453403thalassic
thaler94613103tha_ler
thalers106212263thalers
thallious1243273thallious
thalliums1443253thalliums
thallous1136523thallous
thalweg1442033thalweg
theatric1346133theatric
theelin1038003theelin
thermic1439333thermic
thetic11412893th_etic
thill85918733thill__
thills95515383thill_s
thionic1238893thionic
tholoi9339233tholoi_
thoric114314043th_oric
thrall93810293thrall__
thralled1245803thralled
thralling13256833thralling
thralls10299043thrall_s
thulia936113th_ulia
thymic16307423th_ymic
toluic837693t_oluic
traffic1544733traffic
tragic93811543tra_gic
trellis739873trellis
wallie93216803_wallie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271287.39018136.3
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.84222786.4
 
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.