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

223 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
thallus103560(None) 
phallus1236061phallus
thallous1136521thallous
callus85317072_callus
challas124414122challas
challis124613462challis
gallus74313202_gallus
hallos95425102_hallos
halls85633782_hall_s
hallux1637362_hallux
tallis63319962t_allis
talls55133432t_all_s
talus55423262t_a_lus
thalamus1343602thalamus
thalers106212262thalers
thalli958922thall_i
thallic1246552thallic
thallious1243272thallious
thallium1344432thallium
thalliums1443252thalliums
thalluses1243902thalluses
thills95515382thill_s
thralls10299042thrall_s
alls46740923__all_s
balls76236413_ball_s
callas84526753_callas
callous93516603_callous
calls75634733_call_s
chablis14368563chablis
chalahs15289883chalahs
chalehs15268803chalehs
chalets122813473chalets
chalks155412143cha_lks
challa114014193chall_a
challah15458323challah
challahs16377563challahs
challie124012853challie
challies133915643challies
challot123613263challot
chally144314293chall_y
chillis124411603chillis
chills114717703chill_s
chillum1435443chillum
chillums1544163chillums
chollas123811353chollas
chylous15107273chylous
dalles74222063_dalles
dhals95415443dha_l_s
falls85727653_fall_s
gallous82813953_gallous
galls64729323_gall_s
ghylls1335143ghyll_s
habus106317143_ha_bus
haikus13538293_haikus
hails85231643_hail_s
hakus125114113_ha_kus
halalas104214083_halalas
halals95018313_halals
halers94926913_halers
hales85449843_ha_les
halids104016133_halids
halitus10339963_halitus
hall75741163_hall__
hallah124115403_hallah
hallahs133912463_hallahs
hallal94415563_hallal
hallel93514093_hallel
hallels103310133_hallels
hallo85127553_hall_o
halloa94918123_halloa
halloas104318463_halloas
halloes104021523_halloes
halloo95118973_halloo
halloos103716743_halloos
hallot95426783_hallot
hallow124818323_hallow
hallows134417393_hallows
halluces1335613_halluces
halmas117017893_halmas
halms105225213_ha_lms
haloes94623863_haloes
halons95720713_halons
halos85230253_ha_los
halts85230103_ha_lts
halvas124714173_halvas
halves124717093_halves
hamulus1235323_hamulus
haoles94919803_haoles
harls85634503_harl_s
haulms11558503_haulms
hauls86123733_haul_s
hellos95321683_hellos
hells85032043_hell_s
hillos94618893_hillos
hills85431353_hill_s
hilus84817643_h_ilus
hollas94616903_hollas
hollos95320633_hollos
hullos94916293_hullos
hulls84923563_hull_s
jealous1438093jealous
khalifs1754073khalifs
lalls55324133_lall_s
malleus92911313_malleus
malls76233433_mall_s
ocellus935983ocellus
palls74332563_pall_s
palpus104210283_palpus
phalli1148263phall_i
phallic1447293phallic
phallism1545713phallism
phallist1338983phallist
phalluses1444263phalluses
phyllos1535583phyllos
prothallus1553173prothallus
rhamnus1233133rhamnus
scalls84218203scall_s
shales94731253sha_les
shall85024053shall__
shallop12348453shallop
shallops13288323shallops
shallot103614133shallot
shallots11319503shallots
shallow13388873shallow
shallows14388863shallows
shaloms1288983shaloms
shamus114112813sha_mus
shauls94913113shaul_s
shawls125411973shawl_s
shells94319523shell_s
shills94519613shill_s
smalls84514123small_s
spalls84217343spall_s
stalls64019933stall_s
tablas83716163t_ablas
tables84524893t_ables
tabus74820923t_a_bus
taels56822073t_ael_s
tailles72516473tailles
tails55634193t_ail_s
talars66021683t_alars
talas55935893t_a_las
talcous939483t_alcous
talcs74817183t_a_lcs
talcum1036953t_alcum
talcums1135513t_alcums
talers64628143t_alers
tales55451373t_a_les
talks94322693t_a_lks
tall47240213t_all__
taller63721963t_aller
tallest7317093t_allest
tallies73624603t_allies
tallish103313583t_allish
tallit63422733t_allit
tallits73215993t_allits
tallol63612223t_allol
tallols73311363t_allols
tallow93714203t_allow
tallows103313743t_allows
tally84526863t_all_y
talons64019443t_alons
taluk94812873t_a_luk
taluks10418283t_aluks
tarsus6310513t_arsus
taus46342733t_a__us
taxus125512483t_a_xus
teals56234133tea_l_s
teazles16308923teazles
tells55828943t_ell_s
tellys9348843t_ellys
thacks154311923tha_cks
thairms1244453thairms
thalami1246083thalami
thaler94613103tha_ler
thalloid1246283thalloid
thalweg1442033thalweg
thalwegs1541623thalwegs
thanes94918983tha_nes
thanks134313133tha_nks
tharms115712243tha_rms
thawers13428483thawers
thawless1434083thawless
thaws116515463tha__ws
thill85918733thill__
thiols95112763thiol_s
thirls95012063thirl_s
tholes94919783th_oles
tholos94213003th_olos
thous86017263th__ous
thrall93810293thrall__
thralled1245803thralled
thrills10398783thrills
thulias1035743thulias
thulium1254473thulium
thuliums1343553thuliums
thurls9418713thurl_s
thus76721473th___us
thymus14324743th_ymus
thyrsus1342693thyrsus
tills54631713t_ill_s
tolls54728433t_oll_s
tolus55024483t__olus
tragus749233tra_gus
trails64622513trail_s
trawls94412393trawl_s
trellis739873trellis
trills64319853trill_s
troilus736413troilus
trolls64613943troll_s
trulls64110283trull_s
tuilles72411923tuilles
tulles63218893t_ulles
tumulus935033tumulus
twills9489793twill_s
valgus1047103_valgus
villus93611223_villus
wallas95719393_wallas
walls85529383_wall_s
walrus956433_walrus
whalers13529703whalers
whales124716943wha_les
zealous1637813zealous

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.453394461.4
2DLD Change Limit1340272236.78019768.0
3Display Results2232230.0802787.5
 (SQL Overall)1786912237.31324434.7
 
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.