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

94 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
sniffle13287651sniffle_
sniffled15276441sniffled
sniffler14296831sniffler
sniffles14257721sniffles
skiffle17225202skiffle_
skiffled19244422skiffled
skiffles18265712skiffles
snaffle13216252snaffle_
snaffled15285212snaffled
snaffles14246042snaffles
sniffed14318182sniff_ed
sniffer13318902sniff_er
sniffier14356642sniffier
sniffiest15236002sniffiest
snifflers15275052snifflers
sniffly16265642sniffl_y
sniglet83612412sni_glet
snuffle13267832snuffle_
snuffled15277032snuffled
snuffler14317412snuffler
snuffles14318412snuffles
swiftlet1444792swiftlet
niffer12378443_niff_er
piffle14418233_piffle_
piffled16366403_piffled
piffles15368763_piffles
riffle124210233_riffle_
riffled14338603_riffled
riffler13328353_riffler
riffles133911163_riffles
scuffle15266893scuffle_
scuffled17256203scuffled
scuffler16286703scuffler
scuffles16287863scuffles
shuffle16276923shuffle_
shuffled18296243shuffled
shuffler17306803shuffler
shuffles17297783shuffles
siffleur1441833s_iffleur
singlet84120113s_inglet
skiffless19243053skiffless
skillet113512153ski_llet
sniff113915863sniff___
sniffable1743773sniffable_
sniffers14257123sniffers
sniffily17154033sniffily
sniffing15227453sniffing
sniffish1744513sniffish
sniffling1644093sniffling
sniffs12378843sniff__s
sniffy15337193sniff__y
snifter10349623sni_fter
sniggle9316833sniggle_
sniggled11275743sniggled
sniggler10396113sniggler
sniggles10307313sniggles
sniglets9276813sni_glets
snippet113310433sni_ppet
sniveled1255463sniveled
sniveler1155253sniveler
snuffed14308073snuff_ed
snuffer13318853snuff_er
snuffier14276943snuffier
snuffiest15246053snuffiest
snufflers15285223snufflers
snufflier1543303snufflier
snuffliest1643503snuffliest
snuffly16305203snuffl_y
souffle13306803souffle_
souffled15276193souffled
souffles14298123souffles
spiffed16257103spiff_ed
spiffied17234823spiffied
spiffier16255883spiffier
spiffies16277993spiffies
spiffiest17235653spiffiest
spikelet1446533spikelet
stiffed14359583stiff_ed
stiffen13286023stiff_en
stiffer13319393stiff_er
stiffest1435683stiffest
stiffie13245773stiffie_
stiffies14258383stiffies
stiffly16235173stiffl_y
stifle93611903sti_fle_
stifled113511093sti_fled
stifler102911473sti_fler
stifles103013393sti_fles
swiftlets1542723swiftlets
whiffet1965343whiff_et
whiffle1933533whiffle_
whiffled2133043whiffled
whiffler2033483whiffler
whiffles2034263whiffles

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.1561145455.1
2DLD Change Limit146162946.90621164.5
3Display Results94940.0303133.3
 (SQL Overall)178691947.09225196.1
 
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.