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

147 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
steadying1415450(None) 
steading103613591stead_ing
readying13410222_readying
staying114017322st_a_ying
steadings11307082stead_ings
stealing93416602stea_ling
steaming114013212stea_ming
straying122912692stra_ying
studying1335552st_udying
toadying1335042_toadying
unsteadying1641792unsteadying
beading113221863_bead_ing
beladying1634763beladying
besteading1446023bestead_ing
breading123515463bread_ing
dreading113712803dread_ing
eddying1335293__eddying
estraying1338293estra_ying
heading122919113_head_ing
kneading1436373knead_ing
leading93419553_lead_ing
pleading123011443plead_ing
readding11411363_readding
reading93327213_read_ing
salarying1336073salarying
saying104325543s__a_ying
scending122610583scend_ing
seagoing1038193s_eagoing
sealing83528563s_ea_ling
seaming103222113s_ea_ming
searing83330923s_ea_ring
seating84130683s_ea_ting
sedating103014113s_edating
seeding93719483s_eed_ing
seedling102610953s_eedling
sending94221373s_end_ing
serrying12167693s_errying
shading123115563s_had_ing
sheafing15329483shea_fing
shealing123415463shea_ling
shearing123915903shea_ring
shearling1336923shearling
sheathing1636873sheathing
sheaving154110253shea_ving
shedding14278113she_dding
shending132511253shend_ing
slaying113316843s_la_ying
sleaving123310983slea_ving
sledding11248503sle_dding
sledging11288183sle_dging
smearing113511753smea_ring
sneaking133211093snea_king
sneaping11349493snea_ping
snedding11246953sne_dding
spading113114383s_pad_ing
spaying133014623s_pa_ying
speaking153212493spea_king
speaning113512243spea_ning
spearing113216103spea_ring
speeding122810933speed_ing
spending122712433spend_ing
splaying14219303spla_ying
spraying14299883spra_ying
spreading1339653spread_ing
squadding2143233squadding
stabbing13238763st_abbing
stabling112913653st_abling
stacking154215083st_acking
staffing15247493st_affing
stagging113310513st_agging
staging93818373st_a_ging
staining9413373st_aining
staking123919803st_a_king
staling83925423st_a_ling
stalking133512223st_alking
stalling95116703st_alling
stamping133310963st_amping
standing103413633st_anding
stanging104013653st_anging
staning83922243st_a_ning
stapling112813153st_apling
staring84527053st_a_ring
starling93017123st_arling
starring92312953st_arring
starting93116173st_arting
starving122510173st_arving
stashing123511583st_ashing
stating83725163st_a_ting
staving113915703st_a_ving
steadied1036563stead_ied
steadier937313stead_ier
steadies9311123stead_ies
steadily1236213stead_ily
steady103510203steady___
stealings10318853stea_lings
steamering1345443steamering
steapsin1044713steapsin_
steapsins1144633steapsins
stearin7312003stea_rin_
stearine8311903stea_rine
stearins8312143stea_rins
steeking133411353ste_eking
steeling93615143ste_eling
steeping113412583ste_eping
steering93916793ste_ering
steeving12359653ste_eving
stemming13408203ste_mming
stepping13329073ste_pping
stereoing1037893stereoing
sterling93615553ste_rling
stetting93410713ste_tting
stewarding1543523stewarding
stewing113412493ste__wing
stimying1437503st_imying
stithying1643703stithying
stodging11277463st_odging
storying12249673st_orying
straddling1343643straddling
strafing122111193stra_fing
straining10410563straining
stranding1149653stranding
strapping1436993strapping
strawing122411623stra_wing
streaking142010323strea_king
streaming12239653strea_ming
striding102713603strid_ing
stroying122410593st_roying
studding1136703st_udding
stying105414573st___ying
stymying1733963st_ymying
sueding92613753sue_d_ing
swaying143610643s_wa_ying
swearing123711443swea_ring
sweating123213023swea_ting
taxying1836183_t_axying
teaching143612603_teaching
teaming103917593_tea_ming
tearing84021493_tea_ring
teasing83918513_tea_sing
teazling1856573_teazling
tedding103210883_te_dding
tending94419163_tend_ing
tidying1238513_t_idying
trading93517973_trad_ing
treading103515333tread_ing
treadling1137503treadling
wearying1546703_wearying

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411477.33020278.4
3Display Results1471470.0602450.0
 (SQL Overall)1786911477.82622833.0
 
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.