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 “sowans” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
sowans9421589(None) 
gowans105512291gowans
rowans95715341rowans
sewans95215901sewans
solans64122491solans
somans84619301somans
sowars94318011sowars
sowens93613151sowens
swans84625011s_wans
ajowans1734002ajowans
bogans95714812bogans
cotans81317922cotans
dewans105215142dewans
diwans105110372diwans
downs94918572dow_ns
gobans94412042gobans
gowan95415742gowan_
gowany13457492gowany
gowns95115102gow_ns
hogans105914312hogans
honans94814502honans
jawans1657842jawans
jowars16369652jowars
koans95818622ko_ans
loans56026462lo_ans
logans76319062logans
lorans65117602lorans
moans74624372mo_ans
noways12127732noways
owns76819582_ow_ns
roans54926442ro_ans
romans84620242romans
rowan85418732rowan_
rowens94515302rowens
sans45153362s__ans
sarans64224432sarans
scans74625102s_cans
seawans10379942seawans
sedans74816092sedans
sewan85921292sewan_
sewars94018622sewars
shorans102812412shorans
shwas116415102shwa_s
skeans104512912skeans
slogans8407982slogans
soaks95220292so_aks
soaps75120712so_aps
soars54732512so_ars
sobas74424252soba_s
socas74026182soca_s
sodas64123542soda_s
sofars94712782sofars
sofas85320712sofa_s
sojas124716392soja_s
solan55328152solan_
soland75115042soland
solands84412342solands
solano65314182solano
solanos74412852solanos
soldans83210402soldans
solons65120022solons
soman75024902soman_
somas76030372soma_s
sonant6621952sonant
sonants7511232sonants
sonars64818972sonars
sons46049552so__ns
soras55041012sora_s
sorns55028422so_rns
soudans8309352soudans
sovrans1036482sovrans
sowar85821342sowa_r
sowcars1236012sowcars
sowers94923442sowers
sowing104222912sowing
sown75127452sow_n_
sows75342492sow__s
soyas84520912soya_s
sozins15510792sozins
spans74528732s_pans
spawns11577922spawns
speans85417142speans
swabs105817272s_wabs
swags94921252s_wags
swains94513952s_wains
swan76631312s_wan_
swang95519722s_wang
swank125318232s_wank
swanks134811562s_wanks
swaps104819202s_waps
swats85726862s_wats
sways115518462s_ways
swoons94511142swoons
swouns9358242swouns
tolans64319272tolans
tomans85419132tomans
towns86018882tow_ns
wans76452272__wans
womans114613652womans

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551992.26636430.3
3Display Results99990.0333000.0
 (SQL Overall)178691992.64267634.7
 
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.