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

106 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
signeting113622(None) 
igniting1037362_igniting
sighting133110862sig_hting
signaling1136562signaling
signing92713962sign__ing
sinewing1267592si_newing
singeing10209932singe_ing
sonneting1037002sonneting
vignetting1542822vignetting
agenting1039383_agenting
bighting15269453big_hting
billeting1236643billeting
bingeing12237643binge_ing
bonneting1236173bonneting
designating1446073designating
dieting93616833di__eting
digesting12208673digesting
dighting142510843dig_hting
dinting93520553di_n_ting
dipnetting1453623dipnetting
fidgeting1544523fidgeting
fighting162710083fig_hting
fileting1239303fi_leting
filleting1335853filleting
fingering1439193fingering
gibbeting1542903gibbeting
gimleting1343863gimleting
gingering1238873gingering
highting16259723hig_hting
hinting113919223hi_n_ting
ignoring1036483_ignoring
ingesting11129623_ingesting
ingoting1039863_ingoting
jiggering1934303jiggering
kinetin11248263ki_netin_
kinetins12228153ki_netins
ligating102212283lig_ating
lighting132811833lig_hting
lingering11310513lingering
linting83820983li_n_ting
migrating13910533migrating
minting103020813mi_n_ting
minuting1139723mi_nuting
picketing1835683picketing
pigmenting1653713pigmenting
reigniting1246373reigniting
righting132610853rig_hting
riveting12139443ri_veting
saggering12197793saggering
sainting93215733sain_ting
scanting113914763scan_ting
scenting113212813scen_ting
secreting1279823secreting
segmenting1445003segmenting
segueing1034983segue_ing
sheeting122712833s_heeting
shinneying17182673shinneying
shunting123610433shun_ting
sickening1635993sickening
sideling101012183si_deling
sieging92613203si__eging
sieving112311233si__eving
sifting113014593si__fting
sighing123311663sig__hing
sightings14256533sig_htings
signalling1243803signalling
signet73621153signet___
signeted1035973signet_ed
signets83311503signet__s
signifying1844413signifying
signorina1043963signorina
signorine1045173signorine
signposting1551443signposting
silencing1245053silencing
silting83320483si__lting
silvering1337923silvering
simmering1467823simmering
simpering1449293simpering
singing93221423si_n_ging
singling101913003si_ngling
sinking123320543si_n_king
sinning83918443si_n_ning
sintering101014803sintering
sinuating1039683sinuating
sistering101213753sistering
siting74126623si___ting
sitting83519633si__tting
situating1038883situating
sklenting1475123sklenting
slanting94115093slan_ting
sleeting93114163s_leeting
slighting1436373slig_hting
sniggering1343763sniggering
socketing1666383socketing
sonnetting1144823sonnetting
stagnating1254973stagnating
stinting93415743stin_ting
stunting92811503stun_ting
suggesting1343593suggesting
sweeting123911313s_weeting
swingeing14144693swinge_ing
telneting1035593telneting
ticketing1635633ticketing
tincting1148883ti_ncting
tingeing10198553tinge_ing
tinting84620603ti_n_ting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411066.26623721.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.73226543.5
 
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.