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

156 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
openings113480(None) 
opening1039921opening_
evenings1234382evenings
omening10310092omening_
opining10311742opining_
penangs10268372_penangs
adenines9310193adenines
ageings9437693age_ings
agentings1134443agentings
awnings11406713_awnings
beings94613033_be_ings
brewings14296693brewings
burnings11387623burnings
cannings113710333cannings
clonings11307433clonings
copings124111843cop__ings
couponings1542783couponings
coverings15217893coverings
cozening20188303cozening_
cunnings11357343cunnings
darnings10378553darnings
dopings11408783dop__ings
dovening13238353dovening_
dozening19236183dozening_
dyeings12374643dye_ings
earnings9419333earnings
endings92910443__endings
evening11310223evening_
feelings12338933feelings
fencings14225663_fencings
finings114311773_finings
forewings1645113forewings
ginnings10366523ginnings
gleanings11244643gleanings
gleyings13283653gleyings
greenings11266663greenings
gunnings10346733gunnings
happenings1842623happenings
heelings12359753heelings
hoppings16306523hop_pings
hornings12238363hornings
innings8329443_innings
ironings9217583ironings
joinings16285243joinings
keening123713153keening_
keepings15345943keepings
kennings13315273kennings
leanings94010183leanings
linings84313073_linings
loanings9348013loanings
meanings11329163meanings
meetings11287413meetings
mendings12338303_mendings
meninges1137433_meninges
minings103912073_minings
modelings1335563modelings
mornings11297923mornings
mournings1243533mournings
noonings9246653noonings
obeying1336543obeying_
offerings1643653offerings
offings14285833o_ffings
olefines1137323olefines
olefins1037493olefin_s
oleines7313393ole_ines
oleins6313523ole_in_s
opalines10311423opalines
openers9339493open_ers
openness1035473openness
opens76118553ope__n_s
operands1146813operands
operants1039483operants
operons91411743operon_s
opines84820703op__ines
oping86322413op__ing_
opinions1045933opinions
opsins8411713op_sin_s
opsonins1045533opsonin_s
opting94514403op_ting_
outings84014753o_utings
outrings92811053outrings
outsings93410333outsings
overing111918053overing_
owning104110333o_wning_
pagings114411063_pagings
palings103915823_palings
parings104219213_parings
pavings134011633_pavings
peeing94618083_peeing_
peelings11339523peelings
peening103318303peening_
peining104619153_peining_
peins76128063_pe_in_s
pekins121812233_pekin_s
penang92511113_penang_
pending114119773_pending_
penis75129323_peni__s
penises9318193_penises
pennies94218813_pennies
pennines103112043_pennines
penning103616493_penning_
pennis84315743_pen_nis
pepinos1137693_pepinos
pettings11349703_pettings
pfennigs1461983pfennigs
piecings1345343piecings
pilings103313613_pilings
pinangs10267793_pinangs
pings85830883_p__ings
pining93726533_pining_
pinkings15338143_pinkings
pipings12338253_pipings
postings112912303postings
pulings103511323_pulings
ravenings13235183ravenings
reedings103510363reedings
reelings94012563reelings
renigs74314593_reni_gs
renins64526453_renin_s
reopening1248823reopening_
ripening1138573ripening_
runnings9326913runnings
seeings84411293_seeings
seemings11337643seemings
sewings11369173_sewings
spacings13287043spacings
spaeings11276253spaeings
spankings16215003spankings
speakings16345933speakings
speaning113512243speaning_
speedings13265403speedings
speerings12276843speerings
spellings12296553spellings
spending122712433spending_
spewing133110453spewing_
spilings11308813spilings
spinnings12294853spinnings
springs104415923sp_rings
tannings9268633tannings
tokening1336463tokening_
toppings13286423top_pings
towelings13234693towelings
turnings9287233turnings
upending12258133upending_
upflings1433733upflings
uppings12257123up_pings
upswings1433003upswings
veinings12306433veinings
venines103516613_venines
venins93816703_venin_s
viewings1533983viewings
wakenings1743043wakenings
warnings12358453warnings
weening114113973weening_
weepings14346483weepings
winnings12327583winnings

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.420425454.8
2DLD Change Limit1461621566.66021946.2
3Display Results1561560.0602600.0
 (SQL Overall)1786911567.14025026.8
 
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.