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

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

95 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
osmunds104288(None) 
osmund933801osmund_
osmunda1041651osmunda
osmundas1141791osmundas
obtunds1033762obtunds
sounds74616182_sounds
abounds10217083abounds
almonds10127953almonds
almuds9378773almu_ds
amends94713283_amends
ascends10388203ascends
astounds964233astounds
bosuns8439383bos_un_s
bounds94415803_bounds
bunds85523543__bunds
cofounds1444713cofounds
commands15318823commands
commends15308463commends
communes143411243communes
cosmids1237633cosm_ids
defunds12376753defunds
demands114311413demands
emends95711433_emends
founds104814193_founds
funds94119253__funds
gerunds935183gerunds
gormands1266563gormands
grounds9228313grounds
hounds104413133_hounds
immunes1136083immunes
islands837323islands
maunds9519653_maunds
mends84927693__mends
minds85427123__minds
mounds93915133_mounds
muds75530653__mu_ds
munis75022003__munis
muns65535923__mun_s
obtund945583obtund_
offends14234293offends
omens75618963o_men_s
oscines9310363oscines
oscules938123oscules
osmics1036463osm_ics
osmious936003osmious
osmiums1134143osmiums
osmoles9138363osmoles
osmols8137313osm_ols
osmoses9138123osmoses
osmosis976573osmosis
osmous8138183osm_ous
osmundine1252383osmundine
osmundines1351723osmundines
ouds56430103o__u_ds
pounds93714383_pounds
pseuds944793pseu_ds
refunds11448623refunds
remands104914883remands
remends105013033remends
reminds104614793reminds
resounds956483resounds
rounds73615623_rounds
sands65228583_s_ands
saunas63915433_saunas
scends95213003_scends
scuds85116243_scu_ds
sends65528243_s_ends
shends105313773_shends
shuns85018143_shun_s
shunts95712023_shunts
skunks9468163_skunks
smuts75415713_smu_ts
solands84412343solands
somans84619303soman_s
sound64420023_sound_
spends94714473_spends
spuds85113673_spu_ds
spunks12349333_spunks
squads164410293_squads
squids16409803_squids
stands75118053_stands
stounds8377823stounds
studs64415873_stu_ds
stuns54719493_stun_s
stunts65615253_stunts
sudds75513593_s_udds
suds56135293_s_u_ds
sunns55017353_s_unns
suns45841903_s_un_s
surds65624663_s_urds
swounds11405643swounds
towmonds1493493towmonds
wounds103811633_wounds
yamuns11336513yamun_s
zounds164310173_zounds

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027957.50317863.1
3Display Results95950.0601583.3
 (SQL Overall)178691957.70323197.6
 
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.