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

74 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
swarthier154378(None) 
earthier1137442_earthier
starchier1436642starchier
swarthiest1644742swarthiest
swarthily1842582swarthily
swather134213602swa_th_er
wartier103413912_wart_ier
worthier1436712_worthier
wrathier1435902_wrathier
artier63419733__art_ier
artsier768943__artsier
earthlier1244303_earthlier
farther1348343_farth_er
healthier1544253healthier
heartier1139093heart_ier
heathier1438343hea_thier
lathier10310833_la_thier
marshier1337593_marshier
partier93520713_part_ier
quartier1737543quart_ier
saltier74318633s_alt_ier
sarkier113413313s_ar_kier
scantier10309983scant_ier
scarier94017873scar__ier
scarifier1446653scarifier
scarrier10298453scar_rier
scattier10267583sca_ttier
scratchier1744343scratchier
searcher13209103search_er
seaworthier1751603seaworthier
shirtier1137943shirt_ier
slather103816073sla_th_er
slatier74016813sla_t_ier
smarmier1235033smar_mier
smarter94113133smart__er
smartie9310173smart_ie_
smarties10312873smart_ies
snarkier12336513snar_kier
snarlier8278183snar_lier
snatchier1455353snatchier
sparkier14298033spar_kier
sparklier1554363sparklier
sparrier10329143spar_rier
sportier102010053sport_ier
starrier8279463star_rier
starter73817883start__er
startler8248793start_ler
stealthier1342863stealthier
swampier1544593swa_mpier
swankier15225503swa_nkier
swarmer1247803swar__mer
swarth126012083swarth___
swarthiness1743383swarthiness
swarths13537323swarth__s
swarthy16466373swarth__y
swasher134011513swa_sh_er
swathe125514113swa_th_e_
swathed144611933swa_th_ed
swathers144512083swa_th_ers
swathes134115513swa_th_es
swathing15248713swa_thing
swatter104113323swa_t_ter
sweatier1147033sweat_ier
sweltrier1242993sweltrier
swirlier1135213swir_lier
swishier1434563sw_ishier
swither133710993sw_ith_er
tartier74123263_tart_ier
unworthier16122483unworthier
warier93722893_war__ier
washier133611153_wa_shier
wealthier1543263wealthier
withier132910493_w_ithier
worthies14310283_worthies

Search took 9 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 Filter1786911486410.410435831.7
2DLD Change Limit148641747.64019455.6
3Display Results74740.0302466.7
 (SQL Overall)178691748.08022115.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.