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

151 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
souffle1330680(None) 
scuffle15266891scuffle
shuffle16276921shuffle
snuffle13267831snuffle
souffled15276191souffled
souffles14298121souffles
bouffe14438312bouff_e
coffle14359042co_ffle
duffle13368532_duffle
muffle14339642_muffle
pouffe14448262pouff_e
ruffle124111672_ruffle
scuffled17256202scuffled
scuffler16286702scuffler
scuffles16287862scuffles
shuffled18296242shuffled
shuffler17306802shuffler
shuffles17297782shuffles
skiffle17225202skiffle
snaffle13216252snaffle
sniffle13287652sniffle
snuffled15277032snuffled
snuffler14317412snuffler
snuffles14318412snuffles
snuffly16305202snuffly
souffleed16272902souffleed
truffle1384892truffle
baffle14399873_baffle
bluffly1833433bluffly
boucle103712783bou_cle
bouffes15388633bouffes
boule74828043bou__le
boulle84614613bou_lle
coffee144113743co_ffee
coffled16297363co_ffled
coffles152610003co_ffles
coiffe1447043coiff_e
couple104415963cou_ple
double94013993dou_ble
duffel13407753_duffel
duffles14308923_duffles
etouffee1462303etouffee
gruffly17413893gruffly
joule124918203jou__le
moufflon1641773moufflon
mouille937843mouille
muffled16377783_muffled
muffler15398343_muffler
muffles153910453_muffles
outflew1336423_outflew
outfly1238273_outfly
piffle14418233_piffle
pouff135215423pouff__
pouffed16365953pouffed
pouffes15408123pouffes
pouffs14418123pouff_s
pouffy17395883pouff_y
purfle112511183_purfle
raffle123910703_raffle
reshuffle1851933reshuffle
riffle124210233_riffle
rouble83913313rou_ble
rouille737493rouille
ruffe114713813_ruff_e
ruffled14369153_ruffled
ruffler13369723_ruffler
ruffles133512273_ruffles
ruffly15336673_ruffly
scuff133914893scuff__
scuffed16298243scuffed
scuffer15328883scuffer
scufflers17285033scufflers
scuffs14419053scuff_s
scumble1337013scumble
scuttle936463scuttle
shufflers18265153shufflers
shuttle1046103shuttle
skiffled19244423skiffled
skiffles18265713skiffles
sluff114016813sluff__
sluffed14308303sluffed
sluffs12349583sluff_s
smuggle11265013smuggle
snaffled15285213snaffled
snaffles14246043snaffles
sniffled15276443sniffled
sniffler14296833sniffler
sniffles14257723sniffles
sniffly16265643sniffly
snuff113514043snuff__
snuffed14308073snuffed
snuffer13318853snuffer
snuffier14276943snuffier
snuffily17124323snuffily
snufflers15285223snufflers
snufflier1543303snufflier
snuffs12358533snuff_s
snuffy15356243snuff_y
snuggle9275713snuggle
sobful1136333sobful_
socle7419573so__cle
soffit1237883so_ffit
softie93312483so_ftie
softly12457763so_ftly
sole46053673so___le
solfege1144223solfege
soluble966103soluble
soubise9118793soubise
soul46435713sou__l_
souled75419823sou__led
soulful1045293soulful
souls55127363sou__ls
soundly1136683soundly
source8410673sou_rce
sourly93612213sou_rly
souse56530773sou__se
soutane7312063soutane
sowable121610753sowable
spurtle937453spurtle
stiffie13245773stiffie
stiffly16235173stiffly
stifle93611903s_tifle
stubble1136843stubble
stuff113817053stuff__
stuffed14328973stuffed
stuffer13349793stuffer
stuffier14336623stuffier
stuffily17124163stuffily
stuffless1543543stuffless
stuffs123810223stuff_s
stuffy15317083stuff_y
stumble1147553stumble
suable83920553s_uable
subfile122010503subfile
subtle82113433s_ubtle
suckle124015963s_uckle
suffer124314513s_uffer
suffice15197573s_uffice
suffix1935233s_uffix
sufflate1456183s_ufflate
suffuse1335443s_uffuse
supple10410203s_upple
toffee123311013to_ffee
tousle64514653tou_sle
touzle15429003tou_zle
truffe1276233truff_e
truffled1563993truffled
truffles1485593truffles
unmuffle1662343unmuffle
waffle15369183_waffle
whiffle1933533whiffle

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271516.73319906.0
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.20224811.3
 
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.