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 “symbols” 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
symbols143552(None) 
symbol1336081symbol_
cymbals16236142cymbals
cymols1377192cym_ols
gambols1238592gambols
sambals115213482sambals
sambos104315192sambo_s
syboes1139342sy_boes
symbions1563932symbions
symbiots1573622symbiots
symboled1644492symboled
symbolic1745152symbolic
symbolise1694882symbolise
symbolism1884652symbolism
symbolist1675952symbolist
tymbals14265722tymbals
ambos95321253_ambo_s
bamboos1348753bamboos
bimboes13498733bimboes
bimbos124610523bimbo_s
cibols1039523_cibols
combos125316613combo_s
cymbal15236913cymbal_
cymol1287623cym_ol_
cymous1388403cym_ous
diobols1036543diobols
dumbos114111083dumbo_s
emboli1037483_emboli
embolus1135543_embolus
emboly1336723_emboly
emboss1087383_emboss
embows1396823_embows
eyebolt1246363eyebolt
eyebolts1343483eyebolts
fynbos1433283fynbo_s
gambol1138223gambol_
gimbals12257823gimbals
gombos114311093gombo_s
gumboils1343893gumboils
gumbos114610873gumbo_s
hymnals1543523hymnals
jumbals18106533jumbals
jumbos17379123jumbo_s
limbos104712143limbo_s
mamboes135011823mamboes
mambos125414493mambo_s
mols65948573__m_ols
mools76027173__mools
obols73715863__obols
osmols8137313osm_ols
pyrrols1235403pyrrols
sabals84618863s_abals
sabots8314693s_abots
safrols1036863safrols
salols64017873s_alols
sambal105215183sambal_
sambars115113843sambars
sambas104219263samb_as
sambo95118013sambo__
samburs11369343samburs
samiels939763samiels
santols73513323santols
schools1249113schools
sheols94614153s_heols
shmoes114612093shm_oes
shools94919003s_hools
sibyls1135303s_ibyls
simious939803simious
simnels976103simnels
simooms1135573simooms
simoons937933simoons
sjamboks2342233sjamboks
skatols1135523skatols
skibobs1542983skibobs
smalls84514123s_malls
smells83914743s_mells
smogs85112163s_m_ogs
smolt74824163s_m_olt
smolts84411883s_m_olts
snools65715873s_nools
sokols10399083s_okols
sols45448163s___ols
sombrous1246603sombrous
sotols63714453s_otols
spambots1443313spambots
spools85115913s_pools
stanols739733stanols
sterols7313443sterols
stools65117023s_tools
summons1158003summons
sumos75720093sum_o_s
sunbows1236023sunbows
sybo9714743sy_bo__
symbion1464043symbion
symbiont1574333symbiont
symbionts1662163symbionts
symbioses1683553symbioses
symbiosis16123783symbiosis
symbiot1465273symbiot
symbiote1563233symbiote
symbiotes1682913symbiotes
symboling1744933symboling
symbolised1883473symbolised
symbolises17114643symbolises
symbolisms1983913symbolisms
symbolists1764363symbolists
symbolize2564633symbolize
symbolizes2664373symbolizes
symbolled1742823symbolled
symbology2044263symbology
symptoms1743733symptoms
syncoms1435943syncoms
synods1077953sy_nods
syphons1537503syphons
sysops1136013sy_sops
systole1035763systole
systoles1146473systoles
thymols1533843thym_ols
timbals11239533timbals
tombola1146093tombola
tombolas1245993tombolas
tombolo1146103tombolo
tombolos1245093tombolos
tomboys1435703tomboys
tymbal13236823tymbal_
umbels104510593_umbels
umbos94613073_umbo_s
xylols1634173xy_lols

Search took 9 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.1561145455.1
2DLD Change Limit1340271288.25016245.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.45221141.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.