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

294 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
truffe127623(None) 
ruffe114713811_ruffe
truffes1356771truffes
truffle1384891truffle
bouffe14438312bouffe
griffe13438092griffe
gruff124712142gruff_
gruffed1544942gruffed
gruffer1475792gruffer
gruffs13337452gruffs
gruffy16396012gruffy
pouffe14448262pouffe
ruff105127652_ruff_
ruffed134312742_ruffed
ruffes124112422_ruffes
ruffle124111672_ruffle
ruffs114516742_ruffs
tartuffe1461902tartuffe
trifle94012882trifle
troffer13125862troffer
truce75118692tru_ce
trudge8318732trudge
true46725852tru__e
truffled1563992truffled
truffles1485592truffles
tuff104528522t_uff_
tuffet122612082t_uffet
tuffs115118262t_uffs
agraffe1443333agraffe
bluff134413833bluff_
bluffed16326433bluffed
bluffer15396883bluffer
bluffs14388373bluffs
bouffes15388633bouffes
bruise83412873bruise
brume95817983bru_me
brute75321783bru_te
buff125229863_buff_
buffed154313143_buffed
buffer144512683_buffer
buffet143113783_buffet
buffi136112203_buffi
buffo135112183_buffo
buffs135519513_buffs
buffy165013373_buffy
chuff164812493chuff_
chuffed19316643chuffed
chuffer18337143chuffer
chuffs17427783chuffs
chuffy20445863chuffy
coiffe1447043coiffe
crude86018573cru_de
cruise84314043cruise
cruse75726103cru_se
cuff125327993_cuff_
cuffed154311213_cuffed
cuffs135017493_cuffs
draff125615663draff_
draffs13617903draffs
draffy16486633draffy
drudge9317903drudge
drupe85012993dru_pe
druse64817663dru_se
duff114326643_duff_
duffel13407753_duffel
duffer134711663_duffer
duffle13368533_duffle
duffs125216623_duffs
etouffee1462303etouffee
fluff103913613fluff_
fluffed13295903fluffed
fluffer12336503fluffer
fluffs11347783fluffs
fluffy14315783fluffy
gaffe124111653_gaffe
gauffer1474423gauffer
giraffe1442993giraffe
griff124416463griff_
griffes14367923griffes
griffs13398993griffs
grudge9388583grudge
grue55825713gru__e
gruffest1544593gruffest
gruffier1544703gruffier
gruffly17413893gruffly
grume86218163gru_me
grunge8359583grunge
guff114624933_guff_
guffs124414823_guffs
huff135623843_huff_
huffed163710153_huffed
huffs144514743_huffs
huffy174810233_huffy
luff104426703_luff_
luffa11409023_luffa
luffed133810823_luffed
luffs114516283_luffs
muff124723863_muff_
muffed154210593_muffed
muffle14339643_muffle
muffs134114213_muffs
piaffe1494913piaffe
pouff135215423pouff_
pouffed16365953pouffed
pouffes15408123pouffes
pouffs14418123pouffs
pouffy17395883pouffy
proffer15126933proffer
prude84615973pru_de
prune75119633pru_ne
puff125525433_puff_
puffed153510603_puffed
puffer144610733_puffer
puffs134114933_puffs
puffy164410753_puffy
purfle112511183purfle
raff104933043_raff_
raffle123910703_raffle
raffs115017523_raffs
reffed134712513_reffed
rife74632333_r_ife
riff104430113_riff_
riffed133811563_riffed
riffle124210233_riffle
riffs115114613_riffs
rifle85518333_rifle
rube65532013_ru_be
ruble74521253_ruble
ruche104216763_ruche
rude55632793_ru_de
rue35549263_ru__e
ruffled14369153_ruffled
ruffler13369723_ruffler
ruffles133512273_ruffles
ruffly15336673_ruffly
rugae65114763_rugae
rule49938423_ru_le
rune45236303_ru_ne
rupee7321283_rupee
ruse45938933_ru_se
scruff1437963scruff_
scruffs1554173scruffs
scruffy1842643scruffy
scuff133914893scuff_
scuffed16298243scuffed
scuffer15328883scuffer
scuffle15266893scuffle
scuffs14419053scuffs
shuffle16276923shuffle
sluff114016813sluff_
sluffed14308303sluffed
sluffs12349583sluffs
snuff113514043snuff_
snuffed14308073snuffed
snuffer13318853snuffer
snuffle13267833snuffle
snuffs12358533snuffs
snuffy15356243snuffy
souffle13306803souffle
strafe95215983str_afe
strife95318363str_ife
strumae9368093strumae
stuff113817053stuff_
stuffed14328973stuffed
stuffer13349793stuffer
stuffs123810223stuffs
stuffy15317083stuffy
suffer124314513_suffer
taffy145110823t_affy
tariff12711363tariff_
tariffed1533723tariffed
tariffs1334593tariffs
tartufe1064673tartufe
tartuffes1551623tartuffes
taupe7314173tau_pe
teff106023763t_eff_
teffs115111733t_effs
tiff104727733t_iff_
tiffed13368393t_iffed
tiffs114414883t_iffs
toff105929903t_off_
toffee123311013toffee
toffs116016723t_offs
toffy145310283t_offy
torulae758553torulae
touche114916173touche
toupee8316133toupee
touse55430673tou_se
tousle64514653tousle
touzle15429003touzle
trace75829613tr_ace
trade65026043tr_ade
traffic1544733traffic
trance84718763trance
trave85223033tr_ave
treble8311663treble
tree47745813tr__ee
tref77030993tr_ef_
trefah1235093trefah
triage72812893triage
tribe74420273tr_ibe
trice75127493tr_ice
triene64316383triene
trifid1039063trifid
trifled113711963trifled
trifler103912153trifler
trifles103814833trifles
trike95320163tr_ike
trine54734603tr_ine
triode75311893triode
triose64715383triose
tripe75425383tr_ipe
triple84215923triple
triste63818643triste
trite54730033tr_ite
triune64210183triune
troche113112513troche
trode65322853tr_ode
troffers14125433troffers
troke94821053tr_oke
trompe105611263trompe
trone55131863tr_one
trope75725803tr_ope
trouble957713trouble
trounce936823trounce
troupe84812433troupe
trove85221923tr_ove
truant6315783truant
truced95312053truced
truces84916333truces
truck116115463tru_ck
trucked143910813trucked
trucker134010733trucker
truckle13358863truckle
trucks124711973trucks
trudged10298043trudged
trudgen9357053trudgen
trudger9338733trudger
trudges9339993trudges
trued65117693tru_ed
truer54916643tru_er
trues54925323tru_es
truest64816193truest
trug55720043tru__g
trugs65516803tru_gs
truing73913933truing
truism8118623truism
trull54012673tru_ll
trulls64110283trulls
truly84111553tru_ly
trump95615123tru_mp
trumped12439713trumped
trumpet113810723trumpet
trumps104611883trumps
trundle8307873trundle
trunk94713043tru_nk
trunked12358413trunked
trunks10429753trunks
trunnel745403trunnel
truss54916923tru_ss
trussed84010033trussed
trusser74010263trusser
trusses73813643trusses
trust55426853tru_st
trusted83412793trusted
trustee73514443trustee
truster73114313truster
trusts64714433trusts
trusty94710113trusty
truth85214153tru_th
truths9449503truths
tryste9399583tryste
tubae74716643t_ubae
tube65828663t_u_be
tufa75016613t_u_fa
tufas85314383t_ufas
tuffets13266523t_uffets
tuft76929513t_u_ft
tufted10359283t_ufted
tufter9319933t_ufter
tufts85713273t_ufts
tufty114810413t_ufty
tule45735873t_u_le
tulle54019933t_ulle
tune45635863t_u_ne
tuque14469193t_uque
turf75334053t_urf_
turfed103110963turfed
turfier10249793turfier
turfmen1244163turfmen
turfs84620443t_urfs
turfy114315403t_urfy
turtle63213573turtle
tutee5423523t_utee

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162945.62320045.5
3Display Results2942940.0963062.5
 (SQL Overall)1786912946.12529174.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.