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

110 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
society123608(None) 
moiety1148222mo_iety
satiety1038202satiety
sobriety1343902sobriety
societal1045722societal
socket123923522socket_
sockets134012982sockets
soviet9720152soviet_
soviets1087292soviets
anxiety1744033anxiety
cecity1398153ceci_ty
city95122623__ci_ty
comity13312713comi_ty
docilely1443993docilely
docility1447123docility
docket134721173docket_
dockets144412243dockets
dubiety1344583dubiety
gaiety10119373_gaiety
hockey184813153hocke_y
hosiery13337183hosiery
impiety1445093impiety
jockey22408033jocke_y
locket123922473locket_
lockets134612203lockets
mockery18376913mockery
nicety1138433nic_ety
nimiety1244633nimiety
ochery14319443_ochery
octet7324063_octet_
octets839403_octets
piety105817303__piety
pocket144622623pocket_
pockets154612253pockets
pointy114913283po_inty
polity113015863poli_ty
rackety16499113rackety
rickety16478313rickety
rochet115423003rochet_
rochets124213473rochets
rockery16439253rockery
rocket125425283rocket_
rocketry1744503rocketry
rockets134615363rockets
sachet114725773sachet_
sachets123914103sachets
sacristy1345103sacristy
safety12206913s_afety
sanity9316203sani_ty
scanty114014663s_canty
scatty115310653s_catty
screwy14659453s_crewy
secrecy1444743secrecy
secret8325063secret_
secrete9311073secrete
secretly1345183secretly
secrets9311773secrets
shifty15409263s_hifty
shirty124312563s_hirty
shitty124110063s_hitty
shrieky17364803shrieky
silty84721633s__ilty
sixty154912733s__ixty
skiey125012893s_kie_y
sleety94112653s_leety
slitty9329163s_litty
sobeit8315363sobeit_
soccer1038543socce_r
soccers1138393soccers
sociably1546793sociably
social8813333soci_al
sociality1447953sociality
socially1338543socially
socials999633socials
societally1553973societally
societies1148803societies
sociometry1773923sociometry
socked134721503socke_d
socketed15177343socketed
sockeye1666413sockeye
socle7419573socle__
socles8418453socle_s
socmen1039193socme_n
softy115414483so__fty
soldiery12254613soldiery
solely93714213so_lely
solidity1248113solidity
solidly1137353solidly
somite84519373somi_te
somites94219123somites
sonnet65923503sonnet_
sonnets74211993sonnets
sooey84522433so_oe_y
sooty84924843so__oty
sopite84917713sopi_te
sopited104211063sopited
sopites93817173sopites
sorbet83924083sorbet_
sorbets93012513sorbets
sorcery1237033sorcery
sorely94618013so_rely
sorites73825243sorites
spicery14499013spicery
spicey134414233spice_y
squinty19287063squinty
subsociety1752753subsociety
suety85318493s__uety
surety93515013s_urety
ubiety1135913_ubiety
variety1337743variety

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271106.70319995.1
3Display Results1101100.0333333.3
 (SQL Overall)1786911106.89225927.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.