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

249 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
trellis73987(None) 
tallis63319962t_allis
tellies73820502t_ellies
tells55828942t_ell_s
tellys9348842t_ellys
trebles9311442trebles
trellised1044652trellised
trellises947022trellises
trills64319852trill_s
trollies8310232trollies
trolls64613942troll_s
trulls64110282trull_s
areolas71013863areolas
areoles71016953areoles
argalis84214193argalis
belles85325993_belles
bellies94023723_bellies
bells76432163_bell_s
brewis11469983bre_wis
brillos9369183brillos
brills84916293brill_s
brollies1039533brollies
ceilis85413743_ceilis
celli76717693_celli_
cellist9314423_cellist
cellos84517803_cellos
cells75428063_cell_s
challis124613463challis
chillis124411603chillis
creels84416943creel_s
creoles9913323creoles
creolise1037863creolise
cullis84115993_cullis
delis64928543_de_lis
dellies83622213_dellies
dells66630943_dell_s
drills74414203drill_s
drolls75312393droll_s
duelli767003duelli_
duellist986333duellist
duellos845763duellos
dwells10417713dwell_s
ells46431353__ell_s
fellas95116963_fellas
fellies104119743_fellies
fells85327383_fell_s
follis93113903_follis
frills94414223frill_s
gremlin1035563gremlin
gremlins1136053gremlins
grilles83715023grilles
grills74314803grill_s
hellish13310723_hellish
hellos95321683_hellos
hells85032043_hell_s
ireless72312243ireless
jellies143816533_jellies
jellos134714283_jellos
jells125522163_jell_s
kellies113516853_kellies
knells10439253knell_s
kremlin1344213kremlin
kremlins1444483kremlins
krills104211283krill_s
kvells13346613kvell_s
mells75031333_mell_s
morelles10710493morelles
morellos10136953morellos
mueslis935493mueslis
nellie63614813_nellie
nellies73418723_nellies
nerolis71012773nerolis
nielli636303nielli_
niellist848353niellist
niellos736143niellos
ocelli836843ocelli_
ocellus935983ocellus
paellas9411413paellas
pelvis113610323_pelvis
precis103416703pre_cis
prelim10311423pre_lim
prelims1139823prelims
prills84015613prill_s
quells15359703quell_s
rallies73823343_rallies
reales64934123_reales
realia6314593_realia
realise73021813_realise
realism93115923_realism
realist73225383_realist
realms84913493_realms
reals55038653_real_s
reels55333263_reel_s
reflies104418533_reflies
reis45343233_re__is
relaid75518443_relaid
relays94316753_relays
relets64025673_relets
relic74623363_re_lic
relics84517903_relics
relies65036423_relies
relish93916953_re_lish
relist64628413_re_list
relit55340683_re_lit
reoils64516873_reoils
replies94521043_replies
rilles64725503_rilles
rills55032713_rill_s
rolls55326233_roll_s
selles64426983_selles
sells55134433_sell_s
shells94319523shell_s
skells105013783skell_s
smells83914743smell_s
snells64614203snell_s
spells84617683spell_s
stellas72813043stellas
streels73811343streel_s
strolls739183stroll_s
swells93913983swell_s
tabulis938833tabulis
taels56822073tae_l_s
tailles72516473tailles
tallies73624603t_allies
tallish103313583t_allish
tallit63422733t_allit
tallits73215993t_allits
talls55133433t_all_s
teals56234133t_eal_s
teels55726373t_eel_s
telcos8710683t_elcos
teles54536003t_e_les
telesis7310793t_elesis
telia55821143t_e_lia
telic76019823t_e_lic
tell44934703t_ell__
teller63519823t_eller
tellers73717603t_ellers
telling83321083t_elling
telly84920823t_ell_y
teloi54217383t_eloi_
telos55424523t_e_los
tels46841693t_e_l_s
tennis64015303t_ennis
tenuis64213083t_enuis
terais64023513t_erais
terrellas944293terrellas
teslas64212173t_eslas
testis64916713t_estis
tetris62816293t_etris
thalli958923thalli_
thallic1246553thallic
thallus1035603thallus
theelin1038003theelin
theelins1137643theelins
thelitis1147513thelitis
thesis94913733the_sis
thills95515383thill_s
thralls10299043thrall_s
thrills10398783thrill_s
tieless72512563tieless
tills54631713t_ill_s
tireless82510263tireless
tmesis8529793tme_sis
toeless72612393toeless
tolls54728433t_oll_s
trails64622513trail_s
tramells10327833tramell_s
travois1037883travois
trawls94412393trawl_s
treacles1039703treacles
treadles939703treadles
treads74817923tre_ads
treaties8316983treaties
treatise8311103treatise
treats64821693tre_ats
treble8311663trebl_e
trebled1038483trebled
trebling1139873trebling
trebly1138973trebl_y
treddles1036263treddles
treeless839283treeless
treelike1237003treelike
treens65317873tre_ens
trees55835763tre__es
trefoil1066063trefoil
trefoils1145303trefoils
trehalas1144883trehalas
treks96016853tre__ks
trellising1144663trellising
trembles1237353trembles
tremolos1046043tremolos
tremors93711233tremors
trenail7410813trenail
trenails869843trenails
trendies9312213trendies
trends75513543tre_nds
trepans92311593trepans
trepid9310083tre_pid
tres46542903tre___s
tress55423163tre__ss
tresses73719543tresses
trestles83012553trestles
trets55928023tre__ts
trevallies1343463trevallies
trevallys1542213trevallys
trevets10499973trevets
trews86118893tre__ws
treys85018213tre__ys
trials64319883trial_s
trifles103814823trifles
trilbies1037693trilbies
trill55122933trill__
trilled84116313trilled
triller74215893triller
trillers83613493trillers
trilling92815963trilling
trillion847973trillion
trillions947183trillions
trillium1046203trillium
trilliums1144333trilliums
triols66117803triol_s
triples94616873triples
tripolis1038713tripolis
troilism1047193troilism
troilus736413troilus
trois57226093tr__ois
troll54416533troll__
trolled84312263trolled
troller73913173troller
trollers83211213trollers
trolley10328753trolley
trolleys11315693trolleys
trollied935893trollied
trolling93212493trolling
trollings10286693trollings
trollop944793trollop
trollops1044813trollops
trolly94012363troll_y
trull54012673trull__
tuilles72411923tuilles
tulles63218893t_ulles
twelves1334303twelves
twills9489793twill_s
virelais1146413virelais
wellie92814913_wellie
wellies103719073_wellies
wells85426193_well_s
yells85821943_yell_s

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.406440125.6
2DLD Change Limit1340272496.25021444.3
3Display Results2492490.0803112.5
 (SQL Overall)1786912496.73626527.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.