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

150 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
thinkings1725505(None) 
thinking16289861thinking_
chinking183210892chinking_
drinkings15244772drinkings
pinkings15338142_pinkings
thanking16409522thanking_
thinkingly2143132thinkingly
thinning12319092thinning_
thunking16196952thunking_
tickings15368582t_ickings
tinklings14224662t_inklings
tintings9288712t_intings
twinklings1841882twinklings
twinnings13253662twinnings
bankings15489403_bankings
bethinking2044043bethinking_
bindings123810473_bindings
blinking153510623blinking_
boinking15378423boinking_
chining133316843chin_ing_
chinning14329653chinning_
chirking18339383chirking_
chitlings15255903chitlings
chunking18328053chunking_
clinking153611663clinking_
dinking133618283_dinking_
drinking14308913drinking_
findings13328443_findings
finings114311773_fin_ings
finking154016603_finking_
ginnings10366523_ginnings
hangings13258583_hangings
hanking154619103_hanking_
hawkings19336133_hawkings
hidings12349703_hi_dings
hiking143617103_hi_king_
hildings13347503_hildings
hinging123917123_hinging_
hinting113919223_hinting_
hissings12556753_hissings
honking153414793_honking_
huntings12328053_huntings
huskings16276043_huskings
inking115119053__inking_
inklings13246383__inklings
innings8329443__innings
jinking193613543_jinking_
joinings16285243join_ings
kinking113615153_kinking_
lickings15298143_lickings
likings12539413_li_kings
linings84313073_lin_ings
linking123818253_linking_
minings103912073_min_ings
oinking123714713_oinking_
paintings12327093paintings
pickings17359383_pickings
pinking143918943_pinking_
plankings16326113plankings
plinking153611243plinking_
prickings18315653prickings
prinking153212453prinking_
printings12268103printings
rankings13389173_rankings
reinking13311023reinking_
rethinking1845183rethinking_
rinsings9318013_rinsings
shanking163612283shanking_
shielings13237123shielings
shillings13348093shillings
shindigs13284203shindi_gs
shining113816523shin_ing_
shinning123211023shinning_
shippings17275683shippings
shirking163210473shirking_
shirrings13245323shirrings
shirtings13276603shirtings
shrinking1735653shrinking_
shuckings19273853shuckings
sinking123320543_sinking_
skinking12299773skinking_
slinking133412983slinking_
spankings16215003spankings
spinnings12294853spinnings
stinking133113543stinking_
stringings1245233stringings
swingings14275053swingings
swinking163410323swinking_
tailings93211673tai_lings
tainting93613583tainting_
takings124512573t__akings
talkings13358403t_alkings
tanking123918793t_anking_
tankinis12245913t_ankinis
tannings9268633t_annings
thacking183110043thacking_
thiamines1446383thiamines
thiamins1346633thiamin_s
thiazines2144643thiazines
thiazins2045313thiazin_s
thickenings2151683thickenings
thickens17266413thicken_s
thieving1535143thieving_
things104914303th___ings
thinkers15308703think_ers
thinkingness2051773thinkingness
thinks134613363think___s
thionines12106973thionines
thionins1177923thionin_s
thirling12248583thirling_
ticking143218753t_icking_
tidings93810263t_i_dings
tilings84212793t_i_lings
timings10279303t_i_mings
tinging93619463t_inging_
tining74927543t_in_ing_
tinkling13239233t_inkling_
tinning83117283t_inning_
tinting84620603t_inting_
tithings12327693t_ithings
trackings16247543trackings
trainings10246723train_ings
tricking152714513tricking_
triflings13235973triflings
trimmings14254453trimmings
trining82919213trin_ing_
trippings14225723trippings
trithings13246603trithings
truckings16235023truckings
turnings9287233turn_ings
twillings13234913twillings
twinging13278423twinging_
twining113211443twin_ing_
twinkies1535983twinki_es
twinkling1743643twinkling_
twinning12367043twinning_
twistings13264353twistings
unthinking1844663unthinking_
veinings12306433vein_ings
vikings15386623_vi_kings
whingdings1941813whingdings
whinging16247743whinging_
whining143311673whin_ing_
whippings20284183whippings
whisking19286613whisking_
whitings15287063whi_tings
wickings18357183_wickings
windings13329973_windings
winking153317963_winking_
winnings12327583_winnings

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411508.34317816.3
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.57920828.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.