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

70 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
sheriffs1725392(None) 
sheriff16287691sheriff_
sherifs13299681sheri_fs
serifs94017052s_eri_fs
sharifs13279902shari_fs
shereefs1433862shereefs
sherif122915242sheri_f_
shrifts1335962sh_rifts
shroffs1634362sh_roffs
griffs13398993__griffs
heriots10312063_heriots
midriffs1742533midriffs
riffs115114613___riffs
scruffs1554173s_cruffs
seifs85019333s_e_i_fs
serfs84922013s_er__fs
serials73919743s_erials
series64540973s_eri_es
serif84132133s_eri_f_
serifed11811463s_erifed
seriffed1594973s_eriffed
serines74229543s_erines
serins64029673s_eri_ns
serious73616283s_erious
setoffs1334133s_etoffs
sferics1236133sferi_cs
shariahs14206393shariahs
sharias102516003shari_as
sharif122917123shari_f_
sheafs124912883she__afs
shearings13337563shearings
sheikhs17233993she_ikhs
sheiks132510013she_i_ks
sheilas1059403she_ilas
sherbets1335213sherbets
sherds105614723sher__ds
shereef1337743shereef_
sheriffdom226713sheriffdom
sheriffdoms236653sheriffdoms
sheroots1137863sheroots
sherpas1238093sher_pas
sherries111812893sherries
sherris10168803sher_ris
sherrises12156863sherrises
shifts124412943sh__ifts
shorings12269483shorings
showoffs2042453showoffs
shrieks14377673sh_rieks
shrift12413543sh_ri_ft
shrikes144412393sh_rikes
shrills10389933sh_rills
shrimps14516753sh_rimps
shrines104618693sh_rines
shrinks14397913sh_rinks
shris84221453sh_ri__s
shrives134416173sh_rives
shroff1538503sh_roff_
shutoffs1752073shutoffs
skiffs16327013s__kiffs
sniffs12378843s__niffs
spherics1537073spheri_cs
spiffs14328473s__piffs
spliffs1533563s_pliffs
stiffs12389963s__tiffs
strifes104716583s_trifes
tariffs1334593_tariffs
theriacs1336543theriacs
therians1138313therians
thrifts1335523th_rifts
whiffs1835083wh__iffs

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 Filter1786911461620.420425454.8
2DLD Change Limit146162706.81321453.4
3Display Results70700.0302333.3
 (SQL Overall)178691707.26324602.9
 
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.