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

121 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
signeted103597(None) 
ignited9137622_ignited
sighted123111522sig_hted
signaled1035392signaled
signed83413752sign__ed
signee73617232signe_e_
signees83510802signe_es
signet73621152signet__
signets83311502signet_s
sinewed1137052si_newed
sonneted936182sonneted
vignetted1443492vignetted
agented939423_agented
bighted142810923big_hted
bigoted11258403big_oted
billeted1137643billeted
bonneted1136223bonneted
designated1345933designated
dieted83115493di__eted
digested11208163digested
dighted132511493dig_hted
dinted84419843di_n_ted
dipnetted1343353dipnetted
fidgeted1443893fidgeted
fileted1159093fi_leted
filleted1236603filleted
fingered13128333fingered
gibbeted1492783gibbeted
gimleted1243973gimleted
gingered11127743gingered
highted152710163hig_hted
hinted104318323hi_n_ted
ignite71410583_ignite_
igniter8147673_igniter
ignites81310583_ignites
ignored9226443_ignored
ingested10259003_ingested
ingoted939183_ingoted
isleted837523_isleted
jiggered1834203jiggered
ligated92414143lig_ated
lighted122913503lig_hted
lignite81310303lignite_
lignites9129613lignites
lineated9711063li_neated
lingered10129643lingered
linted74021823li_n_ted
migrated121110513migrated
minted94220583mi_n_ted
minuted10329503mi_nuted
picketed17167383picketed
pigmented1544063pigmented
pigweed1465093pigwe_ed
pinnated11338553pinnated
reignited1145683reignited
righted122912143rig_hted
ringleted1144213ringleted
riveted11258573ri_veted
sacheted14127833sacheted
saggered11237553saggered
sainted84114243sain_ted
scanted104114393scan_ted
scented102811883scen_ted
secreted1138633secreted
segmented1345063segmented
sheeted113813043s_heeted
shinneyed1642083shinneyed
shunted11339783shun_ted
sickened1546783sickened
sieged85212713si__eged
sienite7312713sienite_
sienites8311913sienites
sieved104611443si__eved
sifted104313673si__fted
sighed113712053sig__hed
sighter113412113sig_hter
sigmate10710143sigmate_
signage937773signage_
signages1037483signages
signaler945453signaler
signalled1143843signalled
signer74015633sign__er
signers84714443signe_rs
signeting1136223signeting
signified1446043signified
signore8329093signore_
signposted1451453signposted
silenced1136273silenced
silenter838873silenter
silted74020013si__lted
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
singed85422293si_n_ged
singled93914683si_ngled
sinned73818413si_n_ned
sinter63625923si_n_ter
sintered92213903sintered
sinuated938413sinuated
sistered92612803sistered
sited65130743si___ted
situated938033situated
sklented1335053sklented
slanted83514743slan_ted
sleeted83113223s_leeted
slighted1357393slig_hted
sniggered1243443sniggered
socketed15177343socketed
soignee8279133soigne_e_
sonnetted1044543sonnetted
stagnated1145143stagnated
stinted82914193stin_ted
stunted83010403stun_ted
suggested1243423suggested
telneted935073telneted
ticketed15146643ticketed
tincted1037273ti_ncted
tinted74419533ti_n_ted
vignette1245043vignette
vignetter1343323vignetter
vignettes1344673vignettes

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621217.19020328.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.67223291.3
 
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.