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

68 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
woodsia114417(None) 
woodsias1244921woodsias
woodbin1354872woodbin
woodie103513612wood_ie
woods95723032woods__
woodsier1245472woodsier
woodsman1444792woodsman
woodsy13505922woods_y
alodia71112453alod_ia
anoopsia1044363anoopsia
anopsia9258443anopsia
codeia94112193_codeia
foodie104413843food_ie
foods95924163foods__
footsie1047653footsie
goodie83613993good_ie
goodish1237963goodish
goods75124483goods__
hoodie105116143hood_ie
hoods95124083hoods__
moods85224623moods__
oidia6314953_oid_ia
ossia53710403__ossia
podia8415283_pod_ia
poods85124753poods__
roods65125283roods__
tootsie737133tootsie
whoosis1335453whoosis
whosis1237173who_sis
woads94818443woads__
wolds95420183wolds__
wood85329383wood___
woodbind1543713woodbind
woodbine1444973woodbine
woodbins1445043woodbins
woodbox2043693woodbox
woodchat1743563woodchat
woodcut1344693woodcut
wooded114213683wood_ed
wooden103610303wood_en
woodhen1454723woodhen
woodier113912063woodier
woodies113517153woodies
wooding123012023wooding
woodlot1147023woodlot
woodman1336313woodman
woodmen1356053woodmen
woodpile1444093woodpile
woodshed1644213woodshed
woodsiest1335203woodsiest
woodsmen1444633woodsmen
woodwax2143473woodwax
woodwind1643753woodwind
woody125116883wood__y
woofs114918003woofs__
woolie93514483woo_lie
wools84421463wools__
woolskin1543013woolskin
woomera12135773woomera
woops104917523woops__
woopsed1344733woopsed
woopses1237883woopses
woopsing1435633woopsing
woos76238803woo_s__
woosh113710733woo_s_h
words95425073words__
zooecia1843843zooecia
zoysia1844163_zoysia

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.406440125.6
2DLD Change Limit134027685.62323835.5
3Display Results68680.0332060.6
 (SQL Overall)178691686.06229477.2
 
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.