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 “sniffle” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

154 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
sniffle1328764(None) 
skiffle17225201skiffle
snaffle13216241snaffle
sniffled15276431sniffled
sniffler14296821sniffler
sniffles14257711sniffles
sniffly16265641sniffly
snuffle13267821snuffle
piffle14418232_piffle
riffle124210232_riffle
scuffle15266882scuffle
shuffle16276912shuffle
skiffled19244422skiffled
skiffles18265702skiffles
snaffled15285202snaffled
snaffles14246032snaffles
sniff113915852sniff__
sniffable1743772sniffable
sniffed14318182sniffed
sniffer13318902sniffer
sniffier14356632sniffier
sniffily17154032sniffily
snifflers15275042snifflers
sniffs12378842sniff_s
sniffy15337192sniff_y
sniggle9316832sniggle
snuffled15277022snuffled
snuffler14317402snuffler
snuffles14318402snuffles
snuffly16305192snuffly
souffle13306792souffle
stiffie13245772stiffie
stiffly16235172stiffly
stifle93611902sti_fle
whiffle1933532whiffle
anile54634463ani__le
anisole71010833anisole
baffle14399873_baffle
coffle14359043_coffle
coiffe1447043coiff_e
duffle13368533_duffle
enisle63412093eni_sle
griffe13438093griff_e
knife1210010133kni_f_e
muffle14339643_muffle
nibble103713283_nibble
nickle123814483_nickle
niffer12378443_niffer
niggle83612823_niggle
nimble103412933_nimble
nipple103410373_nipple
piffled16366403_piffled
piffles15368763_piffles
raffle123910703_raffle
riffled14338603_riffled
riffler13328353_riffler
riffles133911163_riffles
rifle85518333_ri_fle
ruffle124111673_ruffle
sanicle91210263sani_cle
scuffled17256193scuffled
scuffler16286693scuffler
scuffles16287853scuffles
senile63420213seni__le
shingle117711273shingle
shuffled18296233shuffled
shuffler17306793shuffler
shuffles17297773shuffles
sickle124418323s_ickle
sidle65124033s_i_dle
siffleur1441833s_iffleur
simile83115623s_imile
simple104315173s_imple
sinful938803sinful_
single74520603s_ingle
sizzle14309613s_izzle
skiable1338883skiable
skiff153612793skiff__
skiffless19243043skiffless
skiffs16327013skiff_s
skittle1135523skittle
smile74823913smi__le
snide64318723sni__de
snidely1136803snidely
sniffers14257123sniffers
sniffiest15235993sniffiest
sniffing15227453sniffing
sniffish1744503sniffish
sniffling1644083sniffling
snifter10349623snifter
sniggled11275743sniggled
sniggler10396113sniggler
sniggles10307313sniggles
sniglet83612413sni_glet
snipe75320573sni__pe
snivel9368853snivel_
sniveled1255463sniveled
sniveler1155253sniveler
snivels10336903snivels
snoozle16305903snoozle
snuff113514043snuff__
snuffed14308063snuffed
snuffer13318843snuffer
snuffier14276933snuffier
snuffily17124313snuffily
snufflers15285213snufflers
snufflier1543293snufflier
snuffs12358523snuff_s
snuffy15356243snuff_y
snuggle9275713snuggle
souffled15276183souffled
souffles14298113souffles
spicule11269933spicule
spiff133616393spiff__
spiffed16257103spiffed
spiffied17234823spiffied
spiffier16255883spiffier
spiffies16277983spiffies
spiffily19153483spiffily
spiffs14328473spiff_s
spiffy17326223spiff_y
spile75230083spi__le
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
stickle132410973stickle
stiff114219233stiff__
stiffed14359583stiffed
stiffen13286023stiffen
stiffer13319393stiffer
stiffies14258373stiffies
stiffs12389963stiff_s
stifled113511093sti_fled
stifler102911463sti_fler
stifles103013383sti_fles
stile54931573sti__le
stipple1146623stipple
stipule936723stipule
subfile122010503subfile
swiftlet1444793swiftlet
swiftly1633733swiftly
swindle11389183swindle
swingle113510563swingle
swiple11379233swi_ple
swipple1444633swipple
swizzle1854103swizzle
trifle94012883tri_fle
truffle1384893truffle
uniface1236953uniface
unmuffle1662343unmuffle
waffle15369183_waffle
whiffled2133043whiffled
whiffler2033483whiffler
whiffles2034263whiffles

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271548.37316007.0
3Display Results1541540.0632444.4
 (SQL Overall)1786911548.57620836.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.