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

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
sheriff1628769(None) 
sherif122915241sheri_f
sheriffs17253921sheriffs
sherifs13299681sherifs
serif84132132s_eri_f
serifs94017052s_erifs
sharif122917122shari_f
sharifs13279902sharifs
shereef1337742shereef
shrift12413542sh_rift
shroff1538502sh_roff
aerify122810113_aerify
cherish15310463cherish
esterify1445623esterify
etherify1744443etherify
griff124416463__griff
hereof123212373_hereof
heriot9422343_heriot
midriff1645513midriff
riff104430103___riff
scarify1537443scarify
scorify1535203scorify
scruff1437963s_cruff
seif75638733s_e_i_f
seifs85019333s_e_ifs
serf76340113s_er__f
serfs84922013s_er_fs
serial64625863s_erial
series64540973s_eries
serifed11811463s_erifed
seriffed1594973s_eriffed
serin55434443s_eri_n
serine65432673s_erine
sering74731813s_ering
serins64029673s_erins
setoff1238913s_etoff
sferics1236133sferics
sharia93116733shari_a
shariah132210533shariah
sharias102516003sharias
sharing113723243sharing
sheaf115424123she__af
sheafs124912883she_afs
shearing123915903shearing
sheering123715103sheering
sheik122514663she_i_k
sheikh16206993she_ikh
sheiks132510013she_iks
sheila969843she_ila
shelf115221113she__lf
sherbet12311383sherbet
sherd96321153sher__d
sherds105614723sher_ds
shereefs1433863shereefs
sheriffdom226713sheriffdom
sheroot10414373sheroot
sherpa1138093sher_pa
sherpas1238093sherpas
sherries111812893sherries
sherris10168803sherris
sherry124510413sher_ry
shewing143812193shewing
shift114225143sh__ift
shoring112820073shoring
showoff1943893showoff
shri76021703sh_ri__
shriek134211103sh_riek
shrifts1335963sh_rifts
shrike134513243sh_rike
shrill94712303sh_rill
shrimp13478773sh_rimp
shrine94920053sh_rine
shrink134511733sh_rink
shris84221453sh_ri_s
shrive125216953sh_rive
shroffs1634363sh_roffs
shutoff1693203shutoff
skiff153612803s__kiff
sniff113915863s__niff
specify1764993specify
spheric14510073spheri_c
spherics1537073spherics
spherier1337783spherier
sphering142811943sphering
spiff133616403s__piff
spliff1438603s_pliff
steric8317063steri_c
sterile7316603sterile
stiff114219243s__tiff
strife95318363s_trife
tariff12711363_tariff
thereof13168063thereof
theriac1239143theriac
therian10311293therian
thrift12412043th_rift
ushering1258923ushering
verify153110163_verify
whereof16185463whereof
whiff17310063wh__iff

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.403443402.0
2DLD Change Limit134027996.05022153.2
3Display Results99990.0303300.0
 (SQL Overall)178691996.48327563.0
 
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.